Good Question!

Few years back I did the same mistake while writing a procedure. Seems my memory is in good condition as I am able to recall that 🙂

Thanks Kenneth.

Good question to brush-up our basics 🙂

Thanks for the question Ron.

After messing-up with LEAD part-1 the other day, this question was easy to solve 🙂

Easy one for Friday 🙂

As COALESCE always picks up the first not null value from LOV, it was easy to guess the answer.

Such good questions can only be anticipated from Ron. Thanks:-)

Thanks for the question. An easy one considering the available answer options 🙂

Unaware of "Halloween Protection", I thought this to be some kind of a funny question [cooked-up] initially 🙂

Got to learn something new, which I was unaware of!

craig 81366 (10/30/2012)

---

Lokesh Vij (10/30/2012)

---

USERID USERNAME SALES

------------------------------

5 XRay...

vk-kirov (10/30/2012)

---

Thanks for question about the new feature of MSSQL 2012!

Lokesh Vij (10/29/2012)

---

Hey Ron, There seems to be some confustion with answer choices here. When we have ORDER BY caluse...

Hi John,

Here is the output what I am getting:

USERID USERNAME SALES

------------------------------

5 ...

Hey Ron, There seems to be some confustion with answer choices here. When we have ORDER BY caluse on Sales, it will order the results in the following fashion:

UserId ...

Nice question. Thanks for Posting.

A trick to catch the glitch.

1) Use SSMS, go to "Query" and select "IntelliSense Enabled"

2) Copy paste the code

3) the syntax error in the...

kapil_kk (10/25/2012)

---

One question, I am confused on this...

select ID, name name from person

select ID ID, name name from person

Both these statements dont give any error message and run successfully...

wht is...

An easy one for Friday 🙂

Apparantly, I noticed that there were 4 select statements in the question and 5 select statements as the answer choice 😀