sqlserver the name is not a valid identifier error in function

参考资料：

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

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