Dineshbabu (1/4/2013)

okbangas (1/4/2013)

Here you are:

create table test (

id int...

okbangas (1/4/2013)

Here you are:

create table test (

id int not...

That's...

Thanks for providing few very good references for Unique constraint.

But all the links gives lot of work arrounds for inserting NULL values. But my question is i have created an...

I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter and that will allow more than...

oh.. unique constraint can allow more than one null value.. I don't think so.. Please give me some xample...

Since last option said Unique key allows NULL values.. he didn't mention xactly one NULL value in the option . so I choosed other 4 and got it correct..

--

Dineshbabu

Nice one...nothing complex.. need to read the Qstn with patience...

--

Dineshbabu

Thanks Dude.

Letz wait for authors reply...

Since i don't have 2012 i'm unable to test it.. But got it correctly by referring Pinal dave's blog. Pls tell me usage of this view.

learnt in begining of college days.. easy one...

Happy new year to all SQL serverCentral guyz..

In first statement both values are rounded to 0 precision then how come on dividing it returns 6 digits after decimal point.

Pls xplain .

Known concept. But took some time understand the full qstn.. nice one..

Thanks for such a nice qstn.

Is there any way to deallocate the unsed pages remains after delete?

As well as please let me know the ways to identify is there...