Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 stupid query tricks

Author  Topic 

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2001-07-11 : 13:35:40
I use the following all the time and thought it was old hat but I did this in front of some "sql server developers" and they looked at me like I was some sort of guru.<shrug>

Select * from tablename where 1=2

This will return the column names only.



Cat
I told you it was stupid. ;)


   

- Advertisement -