从动态SQL中返回值

80酷酷网    80kuku.com

  动态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)















分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: