wow... +1.. nice question.. thanks...

I had little remembrance of Count.

Using SELECT COUNT(*) or SELECT COUNT(1) (which is what I prefer to use) will return the total...

Stewart "Arturius" Campbell (12/12/2014)

---

Heals (12/12/2014)

---

However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least...

Allthough Books Online does not explicitly document this (or I overlooked it), ISNUMERIC is a function that expects a string input parameter. In the second query, the actual input parameter...

Nice easiest question...:-P

Very nice question.... +1 😀

Very simple question. i got 1 :w00t:

Very very very easiest question....:-P

very easy question... 😀

Nice question:-D

nice question... i got 4 points 😀

Clustered Index will created for second table only not for first table. Other wise we can create non clustered index for the first table...

nice question... which scenario's we can use escape clause?

wow nice question... this question make me aware of it.... :w00t:

I am running at sql server 2008 R2... for section 6 i didn't get any error....

Easy question:-)

nice question.. some what useful for interview preparation....