用: CREATE PROCEDURE dbo.Pro内返报表_工序选择 (@GongXuJH nvarchar(100)) AS exec(' SELECT dbo.质量统计.责任人, dbo.质量统计.责任工序, dbo.质量统计.罚款, dbo.质量统计.纸样检验, dbo.质量统计.总检 FROM dbo.质量统计 WHERE (dbo.质量统计.责任工序 in ('+@GongXuJH+'))' ) GO
CREATE PROCEDURE dbo.Pro内返报表_工序选择 (@GongXuJH nvarchar(100)) AS SELECT dbo.质量统计.责任人, dbo.质量统计.责任工序, dbo.质量统计.罚款, dbo.质量统计.纸样检验, dbo.质量统计.总检 FROM dbo.质量统计 WHERE Charindex(','''+dbo.质量统计.责任工序+''',',','+@GongXuJH+',')>0 GO
或: CREATE PROCEDURE dbo.Pro内返报表_工序选择 (@GongXuJH nvarchar(100)) AS SELECT dbo.质量统计.责任人, dbo.质量统计.责任工序, dbo.质量统计.罚款, dbo.质量统计.纸样检验, dbo.质量统计.总检 FROM dbo.质量统计 WHERE charindex(','+dbo.质量统计.责任工序+',',','+@GongXuJH+',')>0
CREATE PROCEDURE dbo.Pro内返报表_工序选择 (@GongXuJH nvarchar(100))
AS
exec('
SELECT dbo.质量统计.责任人, dbo.质量统计.责任工序, dbo.质量统计.罚款,
dbo.质量统计.纸样检验, dbo.质量统计.总检
FROM dbo.质量统计
WHERE (dbo.质量统计.责任工序 in ('+@GongXuJH+'))'
)
GO
AS
SELECT dbo.质量统计.责任人, dbo.质量统计.责任工序, dbo.质量统计.罚款,
dbo.质量统计.纸样检验, dbo.质量统计.总检
FROM dbo.质量统计
WHERE Charindex(','''+dbo.质量统计.责任工序+''',',','+@GongXuJH+',')>0
GO
CREATE PROCEDURE dbo.Pro内返报表_工序选择 (@GongXuJH nvarchar(100))
AS
SELECT dbo.质量统计.责任人, dbo.质量统计.责任工序, dbo.质量统计.罚款,
dbo.质量统计.纸样检验, dbo.质量统计.总检
FROM dbo.质量统计
WHERE charindex(','+dbo.质量统计.责任工序+',',','+@GongXuJH+',')>0