ASP: Interview Questions

[cancer10]

Hey,

I have recently been asked these questions in an interview. Could someone answer them plz?

- Can you create a MS SQL Server 2000 database using an asp page? If yes how, if no why not?

- whats the capacity of bigint datatype in mssql server 2005.

- How will it effect a sql query if i use a varchar datatype instead of a date datatype in ms sqlserver database.



thanx

[Spudhead]

All of the above can be answered by consulting any decent T-SQL reference (http://msdn.microsoft.com/en-us/library/ms189826.aspx).

Why are you asking us to answer your interview questions?

[cancer10]

coz I was not able to answer them :)

[brazenskies]

those are incredibly basic questions!!!

[cancer10]

those are incredibly basic questions!!!


In that case, try answering the first question plz :)

[Spudhead]

Look, I don't want to be rude or anything... but...

Either:

1. You want us to do your interview 'homework' for you.

2. You're genuinely interested, but lack the motivation to go and Google for yourself.

3. You already know the answers and are just testing us to see how good we are.


:confused:

[cancer10]

Neither of them.

Dont bother yourself if you dont wanna help.


Thanx anyway :)