22,301
社区成员




SELECT * FROM View_RESVT WHERE ((WO ='1102027') OR (JOBNO ='1102027')) and 1=1 and PRODLOC='X' order by CODE
SELECT * FROM View_RESVT WHERE ((WO in ('1102027','1102024','1102021')) OR (JOBNO in ('1102027','1102024','1102021'))) and 1=1 and PRODLOC='X' order by CODE
SELECT * FROM View_RESVT WHERE ((WO in ('1102027','','')) OR (JOBNO in ('1102027','',''))) and 1=1 and PRODLOC='X' order by CODE
SELECT * FROM View_RESVT WHERE (WO ='1102027' OR JOBNO ='1102027') and 1=1 and PRODLOC='X' ORDER BY CODE,WO
--@i,@j 拼成你想要的条件
@sql = 'select * from view_resvt where ((wo = @i) or (jobno = @j)) and 1= 1 and prodloc =''X'''
exec (@sql)
SELECT * FROM View_RESVT WHERE CHARINDEX('1102027',(WO,JOBNO))>0
DECLARE @str1 VARCHAR(MAX)
SET @str1 = ',1102027,1102024,1102021,'
SELECT *
FROM View_RESVT
WHERE (CHARINDEX(',' + WO + ',', @str1) > 0 OR CHARINDEX(',' + JOBNO + ',', @str1) > 0)
AND 1 = 1
AND PRODLOC = 'X'
ORDER BY CODE