sqlserver the name is not a valid identifier error in function

程序员文章站 2022-05-18 21:54:41

参考资料：https://*.com/questions/22008859/the-name-is-not-a-valid-identifier-error-in-function 执行存储过程中sql字符串： ......

参考资料：

执行存储过程中sql字符串：

set @name = 'select username from [' + @dbname + '].dbo.users where userid=' + convert(varchar, @userid)  
exec(@name)