简单的存储过程问题

[windala]

失败
1.
create proc sp_query_Goods
@para1 varchar(30),

@sign1 varchar(8)

--@mypara1 varchar(30)

AS

DECLARE @strSql varchar(400)
/*SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'"'+'sdf'+'"'*/
SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'"'+'sdf'+'"'
exec(@strSql)
-----------------------------------------------------
2.
exec sp_query_Goods 'GOODS_UNIT','='

------------------------------------------------
3.
执行成功！！
declare @aa varchar(30)
set @aa='sdf'
SELECT * FROM GOODS WHERE GOODS_UNIT=@aa

1中是我创建的存储过程，字段名、运算符号、参数等都要自己传入。可是一执行就失败！！。请教该如何修改该存储过程。问题应该是在'sdf'那里，是不是要加转义字符之类的。

[windala]

知道了。

[txlicenhe]

那恭喜了

[CrazyFor]

TRY:


create proc sp_query_Goods
@para1 varchar(30),

@sign1 varchar(8)

--@mypara1 varchar(30)

AS

DECLARE @strSql varchar(400)
/*SET @strSql='select * from GOODS WHERE '+@para1+@sign1+''''+'sdf'+''''*/
SET @strSql='select * from GOODS WHERE '+@para1+@sign1+''''+'sdf'+''''

[woyaofengle]

create proc sp_query_Goods
@para1 varchar(30),

@sign1 varchar(8)

--@mypara1 varchar(30)

AS

DECLARE @strSql varchar(400)
/*SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'"'+'sdf'+'"'*/
SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'"'+'sdf'+'"'
exec(@strSql)
-----------------------------------------------------
2.
exec sp_query_Goods 'GOODS_UNIT','='


change into:
create proc sp_query_Goods
@para1 varchar(30),

@sign1 varchar(8)

--@mypara1 varchar(30)

AS

DECLARE @strSql varchar(400)
/*SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'"'+'sdf'+'"'*/
SET @strSql='select * from GOODS WHERE '+@para1+@sign1+''sdf''
exec(@strSql)
-----------------------------------------------------
2.
exec sp_query_Goods 'GOODS_UNIT','='

[woyaofengle]

sorry,please try below:
create proc sp_query_Goods
@para1 varchar(30),

@sign1 varchar(8)
as
DECLARE @strSql varchar(400)
/*SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'"'+'sdf'+'"'*/
SET @strSql='select * from GOODS WHERE '+@para1+@sign1+'''sdf'''
exec(@strSql)

[zjcxc]

知道了?

那我就不再啰嗦了.