Executed query on SSMS and got result NULL. HUUUHHH.

Didn't read select all that apply and just selected NULL and lost a point.

Don't know how many points I lost by not...

Very good question. I was asked this question in an interview.

Q). What's the easiest and fastest way to move data of a table from file1 to file2?

A). Move the...

Check this article - http://support.microsoft.com/kb/916760

For a clean install create a new folder on desktop and in that folder put both Tools and servers folder and then execute setup.exe from Servers...

Excellent and informative article. I, though using SSIS for last couple of years but still love the simple DTS designer tool of SQL Server 2000 version than the complicated...

Tricky question.

Looks like there is lots of disappointment in air today.

Good question. But the real googly would have been if 18003 was included in options in place of 8000 or 16005.

Then you would have seen more wrong answers than...

Excellent article Wagner! A good revision of good SQL and old but basic stuff for any developer to be called a good developer. Thanks again.

you see alias customersa and customersb in the resultset of C. where as in all other queries it's...

I am bad at XML, actually very bad. Have to execute each code in SSMS and then see the difference.

But still, what acually is different in C except that...

Steve, why is that sometimes a very good question holds just 1 point where as a simple question like today's bulk logged holds 2 points ?

Backup recovery model is part...

Select @@TEXTSIZE

in SQL Server 2000 SP4 - result is 64512

in SQL Server 2005 SP3 - result is 2147483647

So, which one is correct?

crispy cracker QOD.

Simple basic question.

http://en.wikipedia.org/wiki/Data_Manipulation_Language

How come Dec 3, 2009 question appeared on sep 14th?

Parthipan,

Try this. It should work.

EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Test',

@recipients = [@empemailid ; @manageremailid],

@body = '@body',

@subject = '@subject'