sqlserver the name is not a valid identifier error in function

在exec 后参数少加了()

SET @Name = 'select UserName from [' + @dbName + '].dbo.Users where UserID=' + CONVERT(VARCHAR, @UserID)  
exec(@Name)

posted on 2022-09-06 12:04  糯米白白  阅读(32)  评论(0编辑  收藏  举报

导航