Posted by --CELKO-- on 08/01/07 22:43

>> best practice when assigning a value to a variable <<

SET is the syntax used in the SQL/PSM Standard. And Standard SQL has
always had a FROM clause with a SELECT.

However SQL Server does not allow row constructors, so you cannot do
things like:

SET (a, b, c) = (1, 2, 3);
SET (a, b, c) = (SELECT x, y, z FROM Foobar WHERE ..);

as soon as they fix that, use SET.

[Back to original message]