+1

Thank you very much.

GilaMonster (3/19/2012)

---

The RowLock (or pageLock) hints just say what the locks should start as, nothing more. In this case they'll start as row, but once past the 5000 or so...

I get it right, but I do not like this kind of question.

😎

R.P.Rozema (3/8/2012)

---

To finalize this: My explanation is wrong and my question + answer was correct only by luck.

The proper explanation has been given in this thread. To be sure I...

R.P.Rozema (3/8/2012)

---

So am I, as I was very sure I had...

R.P.Rozema (3/8/2012)

---

You have left off half of the explanation in your quote. In the next sentence the use of parenthesis to override this behavior is explained:

To preserve duplicates in only...

I get it right, but I disagree with explanation:

If at least one 'Union' is used, duplicates will be removed from the entire final result set, no matter where the 'Union'...

What do you mean for "created and loaded database"?

Good, very good article!

Thank you!

🙂

I couldn't believe, it's too easy!

Same problem if you specify a subquery in the NOT IN clause instead of values.

If one row returned from the subquery contains NULL, the main query doesn't return rows.

SELECT *...

This script demonstrates some problem with implicit conversion:

declare @v-2 varchar(30)

,@f float

-- here you think it is all right and it is

set @f...

This kind of error also is independent from version of sqlserver.

You can not use - * / operators with chars

Very good question.

I really really really learnt a new good feature.

Thank you a lot.

😛

Hugo Kornelis (2/22/2012)

---

Checked and confirmed that it works the same here.

What apparently happens is that SSMS gets all properties from the model database and uses them to pre-populate the properties...