[dba-SQLServer]SET vs SELECT

David Emerson davide at dalyn.co.nz
Tue Oct 7 23:00:43 CDT 2003

I have seen these commands used in similar situations.  Eg

SET @myVar = 10
SELECT @myVar = 10

Are they interchangeable or do they have different purposes?


David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205  

More information about the dba-SQLServer mailing list