kapil190588 (10/5/2012)

---

When I reun the query Select * from test. I got the 2 rows in result while in poll reuslt it mentioned that Query will return 0 rows.

Worng...

kapil190588 (10/5/2012)

---

hi,

I am a newbie in filed of DBa. Can anyone plz explain me how the 41,80 coming while executing--

DECLARE @nvarchar nvarchar(40)

DECLARE @nchar nchar(40)

SET @nvarchar = '7 chars'

SET @nchar...

It wasn't intended as a lecture. It was just me letting off steam after seeing too many messages (not only in this topic, many...

If points are that important for you, you can have one of mine. Heck, you can have all of mine. Last time I checked, the grocery...

carl.landry (10/2/2012)

---

I just don't get what to do with this APPLY keyword.

The query can be redone using a LEFT OUTER JOIN, which results in the same output and the same...

I *knew* when I saw the answer options that there would be a possible source of confusion here.

Yes, the insert into the second table will fail. But that insert is...

The reason for the revival of the thread is that the article was prominently featured in the newsletter.

According...

Knut Boehnert (9/28/2012)

---

A general statement like this is more dangerous than the use of cursors. 😛

Check out http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/21/curious-cursor-optimization-options.aspx. While specialised in its case it counteracts the above general statement and...

A good question; thanks!

However, I did find myself staring at the wording for a bit before answering - and hoping that my interpretation was the correct one. The term "failing"...

Nope!

With the DROP coming after the SELECT, I don't see how it could affect what the SELECT returns?

Run it lots of times. Then read the explanation, the...

Miles Neale (9/19/2012)

---

Thus can you depend on it to be consistent? If in fact "The query will return zero or one row" how can it be consistent? And...

lanre_makinde (9/19/2012)

---

Sorry the explanation is wrong. Then the question is not properly framed. Questions should be aimed at eliciting understanding....

Even if go is not a standard tsql,...

Huh? Why?

SELECT TOP ... without ORDER BY is like saying "give me the first by any order of...