Good Question.I got it correct .I realised this issue long back when am working with insert statements due to mismatch columns.some it will throw exceptions if data type is not...

I got it wrong because in this link they given that witness server exist.

http://msdn.microsoft.com/en-us/library/ms189977.aspx

I also got it correct through elimination of answers.

Hi

I think for 64 bit no need to enable AWE.

Good question.Learned one new thing regarding precedence among UNION,INTERSECT,EXCEPT

Good Question.Thanks

Hugo Kornelis (9/27/2011)

---

I missed it. My bad for not reading the code accurately enough.

Though, with the reversed order of the assignments, one might ownder if the author was trying to...

Thanks for Valuable Question.Keep Posting

Nice question.I got it correct because of hint.even though am using case in sensitive collation

I did not read the 4 the option properly.so i put 1 st option and got wrong.good question.I also so many times about ambigious cloumns.

Great question.Learned new thing today.

Excellent Question.

for testing i executed in my machine. with Australian settings it got hanged.

Ninja's_RGR'us (7/21/2011)

---

malleswarareddy_m (7/20/2011)

---

feel upset by seeing the answer.There is only insert ..select is there.So i choosed 5 answer so that 5 rows got affected.even i tried in ssms also its...

feel upset by seeing the answer.There is only insert ..select is there.So i choosed 5 answer so that 5 rows got affected.even i tried in ssms also its also showing...

Happy Independence Day for all us Assosiates