(0 row(s) affected)

SQL2008 (64-bit) SP2

There are 3 options(Yes, No, Yes by using triggers) and you can check only one of them.

So if it will be Yes by using triggers than also Answer Yes...

I thought that there are radiobuttons not checkboxes 🙂

So I checked only one solution and than I was surprised, that it is wrong 🙂

paul.knibbs (9/6/2011)

---

Knew 4 would fail, but never heard of the problem that would cause #1 to not work...always nice to learn something new! (I mean, I realised the ORDER BY...

Damn it.

I answered correctly, but there was 2 same answers and I choose the wrong one

Or is there some difference between those 2 answers?

1. Vinay, Anup, Amit 2. Vinay, ,...

It is sad If you answer correctly, but it says "wrong answer" 🙁

Correct the question (or the answers)

Just Question.

If extra comma is allowed in create order

CREATE TABLE #TEST (ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,Date datetime,Amount INT,)

Why it is not allowed in SELECT

SELECT ID, DATE, Amount, FROM #TEST

?

comma...

I have the same problem 🙂

U can remove identity and unique keys from select by adding

and i.is_primary_key = 0 and i.is_unique = 0

to both where clauses

I still think, that it is possible. Or I just dont understand the Question.

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