Return value from dynamic SQL

xiaoxiao2021-03-06  66

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)

转载请注明原文地址:https://www.9cbs.com/read-90826.html

New Post(0)