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)
在exec 后参数少加了()
SET @Name = 'select UserName from [' + @dbName + '].dbo.Users where UserID=' + CONVERT(VARCHAR, @UserID)
exec(@Name)