[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?

Regards

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