Very easily got 7 points...

I answered 1,4 &5. Please get my point back.:-)

Today's question is completely misleading. Keeping unique constraint in mind which allows only one NULL value i answered worngly.

Easy one.. Remembering basics...

Easy qstn to start the day.

Hi,

Before answering the question i reffered the below mentioned blog and got it correct.

http://blog.sqlauthority.com/2011/09/07/sql-server-denali-conversion-function-try_parse-a-quick-introduction/

Eventhough u get error message for Parse(), first two rows will be converted to datetime...

Nice question. Today i learnt a new one.

Instead of saying modify using alter script, Author could have said drop and recreate with new name. Luckily igot it correct.

Since there is no such option. I too marked as all excute successfuly.

Hi,

I accept ur answer, object name will be unique to the schema. What is the schema mapped for the current login user. U said we have only two schemas. then...

Thanks man. Reall Great

Please refer this URL. It says by default IT will be ON.

http://msdn.microsoft.com/en-us/library/ms174393(SQL.105).aspx

I Opened a new Sql server management studio and tried the create statement without any set options. Query works fine.

can you xplain in detail?

By Default "Quoted Identifier" Will be ON. Eventhoug if we didn't set any options. the syntax will work fine.

Please correct me if i'm wrong.

ok guyz lets come to a conclusion. Whether question is not clear or we ourselves getting confused?