mistakenly clicked on the NULLS answer... 🙁

nice question, thanks.

Is the same number (16) applicable for a clustered index in SQL Server 2008 ?

Checked the link, could not find if the above number is different in case of clustered...

got it right this time as well...

first time; it was a guess... 😀

nice question... learned something new today...:-)

very nice question... thanks 🙂

thanks Hugo... 🙂

Hugo Kornelis (10/12/2010)

---

I got two points for answering a question that tests no useful skill whatsoever? Come on, Steve! Even one point would have been more than enough...

thanks for this nice example... 🙂

thanks... got to learn something new today.. .:-)

nice & simple... thanks 🙂

thanks, i was looking for an explaination wherein we save the inner transaction...:-)

tommyh (9/23/2010)

---

p0peye (9/23/2010)

---

Please correct me if i am wrong...

My understanding is, you wont be able to commit or...

thanks for this question... i was wondering if you could you provide a question or a query that involves both ROLLBACK WORK & ROLLBACK TRAN 🙂

learned something new today... thanks...:-)

This works on sql 2005... plz. check... you would have commented this line

ALTER TABLE MyTable DROP CONSTRAINT PK_MyId

mukeshkane (9/10/2010)

---

i have checked the same on sql server 2005 on windows server...

nice one thanks...

DECLARE @a INT

DECLARE @b-2 DATETIME

SET @b-2 = @a

implicit conversion from int to datetime works fine 🙂