declare
@TransactorID
int
set @TransactorID = 0
print ( @TransactorID )
-- exec sp_executesql N'select @TransactorID=68 ',N'@TransactorID int
' ,@TransactorID
exec sp_executesql N ' select @TransactorID = 5 ' ,N ' @TransactorID int out
' ,@TransactorID out
print(@TransactorID)
set @TransactorID = 0
print ( @TransactorID )
-- exec sp_executesql N'select @TransactorID=68 ',N'@TransactorID int
' ,@TransactorID
exec sp_executesql N ' select @TransactorID = 5 ' ,N ' @TransactorID int out
' ,@TransactorID out
print(@TransactorID)