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)