I would like to do this :
DECLARE @Id INT;
UPDATE Logins
SET SomeField = 'some value'
OUTPUT @Id = Id
WHERE EmailAddress = @EmailAddress -- this is a parameter of the sproc
Is this even possible? I know I can declare a local table variable and direct the output there but I would prefer to skip it if possible
Best Answer
No, because you are potentially
OUTPUT
ting multiple rows, which wouldn't fit into a scalar variable.You need to output into a
@Table
variable or declared table to handle multiple rows of output.