这里的参数该怎么写，急!!!

[hzyzx]

SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF, COUNT(GP_ZDZ) AS shu, 'Z' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE ''%'+@SS+'%’' /* 这里的参数该怎么写？*/
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF

[hzyzx]

@ss是参数

[hzyzx]

关于引号的问题

[mophi]

LIKE '%'+@SS+'%’

[WangZWang]

SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF, COUNT(GP_ZDZ) AS shu, 'Z' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'''+@SS+'''%' /* 这里的参数该怎么写？*/
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF

[hzyzx]

好象还不行

[hzyzx]

CREATE PROCEDURE [dbo].[ZONGDZ]
@Tmpdbpf char(50) ,@CZ CHAR(50)

AS
DECLARE @SS CHAR(40)
DECLARE @DBPF CHAR(40)
IF EXISTS (SELECT * FROM DYPF WHERE GP_PFNAME=@TMPDBPF)
BEGIN
DECLARE AA CURSOR FOR SELECT GP_PFNO,GP_DBPF FROM DYPF WHERE GP_PFNAME=@TMPDBPF
OPEN AA
fetch next from AA into @SS ,@DBPF
while @@fetch_status=0
BEGIN

SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF, COUNT(GP_ZDZ) AS shu, 'Z' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'''+@SS+'''%'
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF
UNION
SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_YDZ, GP_YWF, COUNT(GP_YDZ) AS shu, 'Y' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'''+@SS+'''%'
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF,GP_YDZ, GP_YWF
END

Close AA
deallocate AA
END
GO
上面这个是我的源代码，请高手指点。

[hzyzx]

CREATE PROCEDURE [dbo].[ZONGDZ]
@Tmpdbpf char(50) ,@CZ CHAR(50)

AS
DECLARE @SS CHAR(40)
DECLARE @DBPF CHAR(40)
IF EXISTS (SELECT * FROM DYPF WHERE GP_PFNAME=@TMPDBPF)
BEGIN
DECLARE AA CURSOR FOR SELECT GP_PFNO,GP_DBPF FROM DYPF WHERE GP_PFNAME=@TMPDBPF
OPEN AA
fetch next from AA into @SS ,@DBPF
while @@fetch_status=0
BEGIN

SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF,
COUNT(GP_ZDZ) AS shu, 'Z' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'''+@SS+'''%'
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF
UNION
SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_YDZ, GP_YWF,
COUNT(GP_YDZ) AS shu, 'Y' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'''+@SS+'''%'
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF,GP_YDZ, GP_YWF
END

Close AA
deallocate AA
END
GO
/*LIKE '%'''+@SS+'''%'这里怎么写？*/

[panjinfu80]

LIKE '%'''+@SS+'''%'
@SS为字符串的
原题的单引号有误的（LIKE ''%'+@SS+'%’' ）比较（LIKE ''%'+@SS+'%'' ），
仔细看一下,倒数第二个单引号。。。

[hzyzx]

zjcxc(邹建) 快来帮帮忙

[zjcxc]

CREATE PROCEDURE [dbo].[ZONGDZ]
@Tmpdbpf char(50) ,@CZ CHAR(50)

AS
DECLARE @SS CHAR(40)
DECLARE @DBPF CHAR(40)
IF EXISTS (SELECT * FROM DYPF WHERE GP_PFNAME=@TMPDBPF)
BEGIN
DECLARE AA CURSOR FOR SELECT GP_PFNO,GP_DBPF FROM DYPF WHERE GP_PFNAME=@TMPDBPF
OPEN AA
fetch next from AA into @SS ,@DBPF
while @@fetch_status=0
BEGIN

SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF,
COUNT(GP_ZDZ) AS shu, 'Z' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'''+@SS+'''%'
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF, GP_ZDZ, GP_ZWF
UNION
SELECT @TMPDBPF AS PFM,GP_CZ,GP_DBPF, GP_YDZ, GP_YWF,
COUNT(GP_YDZ) AS shu, 'Y' AS GP_ZY
FROM dbo.HLZ
WHERE GP_GYPF COLLATE Chinese_PRC_CS_AS_WS LIKE '%'+@SS+'%'
AND GP_DBPF=@DBPF
GROUP BY GP_CZ,GP_DBPF,GP_YDZ, GP_YWF
END

Close AA
deallocate AA
END
GO

[zjcxc]

你不是动态SQL语句,加'干什么?

[hzyzx]

因为我的GP_GYPF 这个字段中可能是ABCDEFGH
当我@ss='A' 我要的是GP_GYPF 中含有A的记录,
我的意思是参数@ss的值变化，我要的记录结果也变化

[hzyzx]

参数@ss的变化取决于@Tmpdbpf char(50) ,@CZ CHAR(50)

[hzyzx]

改成LIKE '%'+@SS+'%' 还是不行

[zjcxc]

举例说明