这个存储过程有啥问题啊！！！

[hssh38]

CREATE PROCEDURE [SearchMateriel]
@KeyWord varchar(50),
@Type varchar(50)，
@Category varchar(50)
AS
exec('select MaterielID,Category,Second_Category,Three_Category,Name from Materiel where '+@Type+' like ''%'+@KeyWord+'%'' and Category='+@Category)
GO

如果不要@Category就没问题，否则语法能通过检测，但就是说Category这部分有问题。谢谢！！！！！！！！！！

[Rewiah]

Category什么类型？如果字符：


CREATE PROCEDURE [SearchMateriel]
@KeyWord varchar(50),
@Type varchar(50)，
@Category varchar(50)
AS
exec('select MaterielID,Category,Second_Category,Three_Category,Name from Materiel where '+@Type+' like ''%'+@KeyWord+'%'' and Category='''+@Category+'''')
GO

[zhujjcn]

@KeyWord varchar(50),
@Type varchar(50)，

为什么你的逗号一个拳脚一个半脚

[hssh38]

to:Rewiah(乘长风)
是字符，varchar的

to:zhujjcn(WhoAmI)
发帖的时候的失误

[pengdali]

try:

CREATE PROCEDURE [SearchMateriel]
@KeyWord varchar(50),
@Type varchar(50),
@Category varchar(50)
AS
exec('select MaterielID,Category,Second_Category,Three_Category,Name from Materiel where '+@Type+' like ''%'+@KeyWord+'%'' and Category='''+@Category+'''')
GO