I knew this one. 🙂

Thanks a lot for the question.

are the columns mutually dependent to occur in the table ?

IF EXISTS

(SELECT * FROM INFORMATION_SCHEMA.Columns WHERE UPPER(TABLE_NAME) = 'NEWTABLE' AND UPPER(COLUMN_NAME) in (@SMcol,@PNcol,@PVcol))

the above code suggests that if any...

L' Eomot Inversé (7/7/2013)

---

Nice easy question, although at first site it looks rather unpleasant.

There are too many questions which would be easy if it was easy to see how many...

easy one.

In case of global temporary table creation it will throw an error. i.e ##Table1

Local Temp just gets another session.

Thanks for the question.

based on the explanation, I guess, you reached the conclusion. The reference reach...

The difference between 'IN' and 'ALL' is that , 'ALL' give true for when all the data satisfies the met condition, where as 'IN' give out the same even one...

Richard Warr (6/17/2013)

---

As only 6% selected the wrong answer it must be down to not selecting three options. If you don't read the...

Coming after a long time and started with this question :w00t:

how come -1 and -10 didn't span the whole number line !!! I got caught in the first...

+1

I wonder how 28 % got it wrong...

Edit :

-- error; incorrect alias

SELECT ProductID Name Color FROM Product

GO

--...

HowardW (6/4/2013)

---

The insert order isn't guaranteed to be the same between two inserts, so the identity trick may not work. Also, I suspect it may allocate identities before the error...

Thanks for the reply , I have modified the original post to uncomment few lines, which actually throws error ..

I am aware of identity column usage to find the row...

Hugo Kornelis (5/6/2013)

---

And I am...

Hugo Kornelis (5/6/2013)

---

demonfox (5/6/2013)

---

I don't see any problem in banal comments , such as "Thanks for the question" , "nice question" ; I think it encourages the author; whereas my...

michaelhitchin (5/6/2013)

---

Hugo Kornelis (5/6/2013)

---

And finally, to Steve - I know we've discussed this before, and I know it won't happen, but I just have to ask again. Can you please,...

I lost patience, the moment I saw "select 8" ...

not a good day to begin with :blink: