用charindex解决从数据库读取结果集用in分隔问题(所查出的条件不重复)
select * from CHARGEITEMS where charindex(convert(nvarchar(128),ID),(select CHARGEITEMS from CHARGEITEM where ID=3))>0
用charindex解决从数据库读取结果集用in分隔问题(所查出的条件不重复)
select * from CHARGEITEMS where charindex(convert(nvarchar(128),ID),(select CHARGEITEMS from CHARGEITEM where ID=3))>0
转载于:https://www.cnblogs.com/GTRBaby/archive/2011/01/27/1945939.html