67720,67725,67742,67861,67862,67870............. 这些参数是怎么来得?假如来自一个表 t.CDBFormalID:SELECT a.CDBFormalID
FROM dbo.CustomerOperationInfo a,t
where a.CDBFormalID= t.CDBFormalID
FROM dbo.CustomerOperationInfo a,t
where a.CDBFormalID= t.CDBFormalID
SELECT a.CDBFormalID
FROM dbo.CustomerOperationInfo a,t
where CDbFornalid >=67000 and CDbFornalid<=67870感觉你写的查询语句没有太大的意思,简直就是把数字组成集合,然后又打印出来了,一点没有查询的意思。
用BETWEEN也可以阿!
如果是做為結果一次返回的﹐也可存入一臨時表﹐將其轉換成字符串型﹐用CharIndex() 來判斷
Insert into #Tmp(LongStr)
Values('67720,67725,67742,67861,67862,67870.............')SELECT t1.CDBFormalID
FROM dbo.CustomerOperationInfo t1, #Tmp t2
where CharIndex(','+t1.CDbFormalid+',',t2.LongStr)>0
個人看法﹐試試可不可用
Values(','+'67720,67725,67742,67861,67862,67870.............'+',')