求SQL语句,where条件中如何加判断
画面上有2个非必需输入的输入框,输入的是codeFrom,codeTo
场景1
如果画面的输入框没有输入数据,选出以下数据
SELECT
TABLE.预定接收方code,
CASE
WHEN View.sysCode = 1 THEN
SELECT Table1.kouzaName1, 1 FROM Table1,View WHERE View.code = TABLE.分类 AND View.kubun = 16 AND TABLE.预定接收方code = Table1.kouzaCode1
WHEN View.sysCode = 2 THEN
SELECT Table2.kouzaName2, 2 FROM Table2,View WHERE View.code = TABLE.分类 AND View.kubun = 16 AND TABLE.预定接收方code = Table2.kouzaCode2
ELSE '',''
END AS 预定接受方名称,syscode
FROM TABLE
场景2
如果画面的输入框输入了数据,选出以下数据
SELECT
预定接收方code,
CASE
WHEN View.sysCode = 1 THEN
SELECT Table1.kouzaName1, 1 FROM Table1,View WHERE View.code = TABLE.分类 AND View.kubun = 16 AND TABLE.预定接收方code = Table1.kouzaCode1
WHEN View.sysCode = 2 THEN
SELECT Table2.kouzaName2, 2 FROM Table2,View WHERE View.code = TABLE.分类 AND View.kubun = 16 AND TABLE.预定接收方code = Table2.kouzaCode2
ELSE '',''
END AS 预定接受方名称,syscode
FROM TABLE
WHERE
if LEN(@画面输入codeFrom) >0
BEGIN
SET @SQL = @SQL + ' syscode = 1 AND 预定接收方code >= ' + CHAR(39) +@画面输入codeFrom + CHAR(39) + ' '
END
if LEN(@画面输入codeTo) >0
BEGIN
SET @SQL = @SQL + ' syscode = 1 AND 预定接收方code <= ' + CHAR(39) +@画面输入codeTO + CHAR(39) + ' '
END
不知道这么写对不对。