|
|
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.
Navigation:
[Reply to this message]
|