CREATE VIEW vw_clients AS

SELECT TOP 100 PERCENT Code, Name FROM Clients

ORDER BY Code

I am curious to know if the VIEW above always returns records in sorted order.

Me, too! 😀

Thanks! I found it very interesting for Regular expression syntax.

I get it wrong, but I like this kind of questions.

Thanks.

tommyh (10/3/2011)

---

There are several problems with this question. One being that you cant declare @Start 2 times.

The other being that the answer is wrong. They both perform equally. I have...

Very simple. Thanks. 🙂

I also use this "Select TOP 50 * FROM ". It is better...

Olga B (9/13/2011)

---

Ah yes, my "favorite" bit of SQL syntax

select 0 [A]

A fun bug to find when I accidentally delete a comma and then try to figure out what's...

Tom.Thomson (9/13/2011)

---

Amusing and fairly easy question.

The misprints in the explanation may have left some people confused. All three alias forms are wrong (1st missing "= <", second and third...

Unfortunately, the editor to contribute with a question, sometime, changes the text both in the question and more often in the explanation. Yesterday, the explanation of "Unary & Aliases" was...

I immediately get it right, because I often fall in these kind of errors.

Of course!

OCTom (8/3/2011)

---

ronmoses (8/3/2011)

---

Carlo Romagnano (8/3/2011)

---

EXISTS check if subquery returns ROWS and does not execute EXPRESSION or read column value. So, in this case divide by zero is never executed, but...

I agree with you.

EXISTS check if subquery returns ROWS and does not execute EXPRESSION or read column value. So, in this case divide by zero is never executed, but ONE ROW exists.