Carlo Romagnano (5/28/2010)

---

Try this:
select*from sysobjects order by 1desc
No space in 1desc

I've seen that too before, same like this:
declare @a int set @a=1select @a
However, select1 or select@a won't work. It seems that a keyword preceded by an integer always works. I would definitely avoid using it though, it only confuses me.

ziangij (5/28/2010)

---

However was wondering, when SSMS executes the query, it would have to do some effort to remove spaces between the words

malleswarareddy_m (5/27/2010)

---

I did not understand this question.in question it shows that to select wrong sytax.but all resturns table data without any error.then i did not found the wrong answer.so i applied three answers.got my point.

So 1st you have to select all the statements that are correct, then guess the error statements?