带参数的存储过程应该怎么写呢@chej是传递的查询条件，那样写会出错

[wanggenhu0]

ALTER PROCEDURE [dbo].[shouYeWuYuan]
(
@ywy nvarchar(50),
@chej nvarchar(500))
AS

begin
if( @ywy='' or @ywy is null)
begin

SELECT xiagsj as 定稿日期,kehuname as 客户
FROM chanpin a



where (a.tingzis!=1 or a.tingzis is null) @chej


order by djsj desc
end
end
@chej是个传递的查询条件，我这里应该怎么写才能不出错，谢谢

[wanggenhu0]

ALTER PROCEDURE [dbo].[shouYeWuYuan]
(
@ywy nvarchar(50),
@sql nvarchar(500))
AS

begin
if( @ywy='' or @ywy is null)
begin

SELECT xiagsj as 定稿日期,kehuname as 客户
FROM chanpin a



where (a.tingzis!=1 or a.tingzis is null) AND kehuname =@sql


order by djsj desc
end
end
这样写就不会出错，但是我的@sql传入的是kehuname ='' and user='' 好几个查询

[wanggenhu0]

顶一顶，回复更快

[吉普赛的歌]

ALTER PROCEDURE [dbo].[shouYeWuYuan]
(
	@ywy nvarchar(50),
	@chej nvarchar(500)
)
AS
BEGIN
	DECLARE @sql NVARCHAR(MAX)
	SET @sql=
'SELECT xiagsj as 定稿日期,kehuname as  客户
FROM chanpin a  
where (a.tingzis!=1 or a.tingzis is null)
@chej
order by djsj desc
'
	SET @sql=REPLACE(@sql,'@chej', CASE WHEN @ywy>'' THEN @chej ELSE '' END)
	PRINT @sql
	EXEC (@sql);
END
GO

用动态SQL

[卖水果的net]

@chej nvarchar(500)) 是一个已经拼接好的条件？

[wanggenhu0]

引用 4 楼 wmxcn2000 的回复:

@chej nvarchar(500))

是一个已经拼接好的条件？

对拼接好的条件