Vienmēr aizmirstu un tad pusdienu meklēju kā to dabūt gatavu.

DECLARE @dummy INT
SET @dummy = 0

print @dummy

EXEC sp_executesql
@query = N’SELECT @dummy = 1′,
@params = N’@dummy INT OUTPUT’,
@dummy = @dummy OUTPUT

print @dummy
select @dummy

Leave a Reply