I agree.

Easy and too long question.

charlietuna (10/23/2011)

---

The solution seems a bit opaque. Something like this is (to me) much more straightforward for the next person who has to read it:

update #t

set col1 = case col1...

In fact, the TOP clause with the "ORDER BY", in this case, is...

paul.knibbs (10/21/2011)

---

Carlo Romagnano (10/21/2011)

---

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...

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...