🙂

What is the Diff B/W...

Hugo Kornelis (1/17/2013)

---

Dineshbabu (1/17/2013)

---

Great question and great concept.

I added COL1 to TblA2 and expected "Ambiguous column name 'col1'.". But this time Sql server selected column from TblA2 and gave...

Great question and great concept.

I added COL1 to TblA2 and expected "Ambiguous column name 'col1'.". But this time Sql server selected column from TblA2 and gave me the correct...

I never tried using TRY ..CATCH in a function. But today i learnt we can't use it.

Tom, thanks for your comments about Return type.

I don't have 2012 to understand it further.

Thanks cfradenburg, Hugo & GilaMonster.

I will take the TSQL part, Changes made to Table variables and Scalar variables will not be affected by Rollback. As well as Identity value will...

Since i'm not well versed with computed columns , referred BOL and answered NO. But SSC kicked me out saying Wrong.

But after reading all the threads posted here by experts...

We are making fun on a such valuable basic question. Eventhough its easier one, it will be very useful for beginners..

If we started making fun like this on simple questions,...

I choosed. Hint overrides SET option and got it wrong.

I answered this with keeping what ever options may be but a statement level hint can overrride everything.

I think i...

Since I worked only in 2005 & above i think got it correct. I don't have idea about earlier versions.

As far as I know anything written between

BEGIN TRAN

.

.

.

ROLLBACK

can...

+1

Mostly i will go for JOins. I have practiced right from the begining like that.. I hate subqueries.

L' Eomot Inversé (2/23/2012)

---

Nice easy question, nice straightforward answer and explanation.

I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation...

Nice and easy one.. AS well as blog by pinal dave which compares performance between NOT IN and JOINS also very useful..

Hugo Kornelis (1/10/2013)

---

Using Management Studio, create the stored procedure as specified in the question, but add...