[dba-SQLServer] interesting trick

Susan Harkins ssharkins at gmail.com
Sun Feb 10 16:14:08 CST 2008


Using SELECT 1 instead of SELECT * -- I know you can use a number to refer 
to a column's position, but its uses are limited. I found this reason 
interesting and probably wouldn't have thought of it on my own.

Susan H.


> Which trick are you referring to? Using an literal in the exist(select)?




More information about the dba-SQLServer mailing list