SQL存储过程基础语法问题，不知道用啥符号~

[glvicky]

CREATE PROCEDURE [月统计]
(
@Year [nvarchar](4),
@Month [nvarchar](2),
@ClassID [int]
)
AS

SELECT SUM(dbo.Order_Product.OP_Price * dbo.Order_Product.OP_ProductNumber)
FROM dbo.Product_Class INNER JOIN
dbo.Product_List ON
dbo.Product_Class.PC_ID = dbo.Product_List.PL_ClassID INNER JOIN
dbo.Order_Product ON
dbo.Product_List.PL_ID = dbo.Order_Product.OP_ProductID
WHERE (',' + dbo.Product_Class.PC_ParentIDs + ',' LIKE '%@ClassID%') AND
(LEFT(dbo.Order_Product.OP_OrderID, 4) = @Year) AND (CONVERT(int,
SUBSTRING(dbo.Order_Product.OP_OrderID, 5, 2)) = @Month)
GO


就是
(',' + dbo.Product_Class.PC_ParentIDs + ',' LIKE '%,@ClassID,%')
这个参数~本来应该是这样的~
(',' + dbo.Product_Class.PC_ParentIDs + ',' LIKE '%,111,%')
可是我不知道怎么连……这样子是不行的吧？取出来是空值~

[chuifengde]

LIKE '%'+@ClassID+'%'

[OracleRoob]

LIKE '%' + @ClassID + '%'

[chuifengde]

LIKE '%'+ltrim(@ClassID)+'%'

[sunshine_zhang]

SELECT SUM(dbo.Order_Product.OP_Price * dbo.Order_Product.OP_ProductNumber)
FROM dbo.Product_Class INNER JOIN
dbo.Product_List ON
dbo.Product_Class.PC_ID = dbo.Product_List.PL_ClassID INNER JOIN
dbo.Order_Product ON
dbo.Product_List.PL_ID = dbo.Order_Product.OP_ProductID
WHERE (dbo.Product_Class.PC_ParentIDs LIKE '%' + @ClassID + '%') AND
(LEFT(dbo.Order_Product.OP_OrderID, 4) = @Year) AND (CONVERT(int,
SUBSTRING(dbo.Order_Product.OP_OrderID, 5, 2)) = @Month)

[glvicky]

谢谢，知道了~
LIKE '%,' + @ClassID + ',%'

[glvicky]

其实~
当@ClassID [int]时，LIKE '%' + @ClassID + '%'是这行的~
把@ClassID [nvarchar](6)....