当我指定模板参数的值时,这对我来说运行良好:
select * from <xyz, varchar,YourTable> WHERE ID<=1000 AND ID>=20000
也许您没有将每个参数的“”正确配对
EDIT我现在看到问题了:
SELECT * FROM <xyz, varchar,YourTable> WHERE ID<=1000 AND ID>=20000 AND <xyz2,varchar,YourColumn> IS NOT NULL
结果是:
SELECT * FROM YourTable WHERE IDYourColumn IS NOT NULL
尝试将“
SELECT * FROM <xyz, varchar,YourTable> WHERE ID<lessthan,char,<>=1000
AND ID>=20000 AND <<xyz2,varchar,YourColumn> IS NOT NULL
结果是:
SELECT * FROM YourTable WHERE ID<=1000
AND ID>=20000 AND YourColumn IS NOT NULL
或者拆分行,换行符似乎有所不同:
SELECT * FROM <xyz, varchar,YourTable> WHERE ID<=1000 AND ID>=20000
AND <xyz2,varchar,YourColumn> IS NOT NULL
结果是:
SELECT * FROM YourTable WHERE ID<=1000 AND ID>=20000
AND YourColumn IS NOT NULL