Thank you Paul... Good Question..Learn lot from this..

Thanks good question :-). For info rmation if we write question like this

declare @a int

declare @b-2 varchar(2)

set @a = 10

set @b-2 =...

Good Question

Hi All,

I got right answer(0,1) in SQL 2005, but this not in the fresh query window, first I executed pervious question query in query window then I executed this one,...

I got right anwser but it's true for the SQL Server 2008 not for SQL Server 2005.

Please Change the question or add one more option with 250.

Thanks bitbucket for a nice question i learnt lot from this....

I changed the table name, Now it works fine in 2005. good Question!

Thanks to Sudhir.

After doing whatever proccess told by Henrico. Database size remain same, and in my database ldf size is 15gb and mdf size is 200mb.

Actually I want to make ldf size...

Thanks Vikas for quick reply, I already use

DBCC SHRINKFILE (DBName, Size)

for reducing my database but it not work. Database base log file size remain same.

I also run a script:-

The answer should be false.

When I run the four statements, I get:

2009-11-16 16:38:22.217Monday

2009-11-16 16:38:22.217Monday

2009-11-16 11:08:22.217Monday

2009-11-16 11:08:22.217Monday

Here time and minutes are different.