(散分)sql语句 问题

[spark_wu]

create procedure test
@name nvarchar(50)
as
begin

declare @s nvarchar(50)
  set @s=@name
 exec('select 员工姓名,Title, count(StateId) [数量] from workstatetj_1 where 员工姓名= '+@s+' group by 员工姓名,Title')

end

exec test '老板'

出现 消息 207，级别 16，状态 1，第 1 行
列名 '老板' 无效。

的问题，请问是什么问题啊，如果 参数是int 类型的就不会出错

急急急！！！！！！！！

[jiangshun]

select '''''',''

/*
          
---- ---- 
''   

（所影响的行数为 1 行）

*/

[beckle_ye]

MARK

[f231358]

jf

[mzjmicrosoft]

/*
          
---- ---- 
''   

（所影响的行数为 1 行）

*/

[tkscascor]

..........

[jenny0810]

[Quote=引用 1 楼 herojams 的回复:]
workstatetj_1 where 员工姓名= '''+@s+''' group by
字符必须用单引号包括起来
[/Quote]dd

[yanglei6979431]

帮顶 接分 楼上已经给出答案了

[randomfeel]

create procedure test 
@name nvarchar(50) 
as 
begin 

declare @s nvarchar(50) 
  set @s=@name 
exec('select 员工姓名,Title, count(StateId) [数量] from workstatetj_1 where 员工姓名= '''+@s+''' group by 员工姓名,Title') 

end

[_see_you_again_]

workstatetj_1 where 员工姓名= '''+@s+''' group by
字符必须用单引号包括起来

[comzheng]

create procedure test
@name nvarchar(50)
as
begin

declare @s nvarchar(50)
set @s=@name
exec('select 员工姓名,Title, count(StateId) [数量] from workstatetj_1 where 员工姓名= ''+@s+'' group by 员工姓名,Title')

end

exec test '老板'

[comzheng]

create procedure test
@name nvarchar(50)
as
begin

declare @s nvarchar(50)
set @s=@name
exec('select 员工姓名,Title, count(StateId) [数量] from workstatetj_1 where 员工姓名= '''+@s+''' group by 员工姓名,Title')

end

exec test '老板'
少了引号。如果@s是整型的话就可以

[cnhuangjin]

语法错误