语句如下:
DECLARE @companyid VARCHAR (100)
SET @companyid='102,103,106,107,108'
SELECT * FROM oCompany WHERE CompanyID IN (@companyid)得不到结果。
如果where CompanyID IN(102,103,106,107,108) 是可以得到结果的。
DECLARE @companyid VARCHAR (100)
SET @companyid='102,103,106,107,108'
SELECT * FROM oCompany WHERE CompanyID IN (@companyid)得不到结果。
如果where CompanyID IN(102,103,106,107,108) 是可以得到结果的。
SET @companyid='102,103,106,107,108'
SELECT *
FROM oCompany
WHERE charindex(CompanyID, @companyid ) > 0
谢谢dcy0927的回复,用charindex函数解决了。同时也谢谢ap0405140的回复。结贴!