各位高手,我的sql语句是这样的
SELECT * FROM DEMO..COPTJ where TJ001>=:P1 UNION all SELECT * FROM SLJX..COPTJ WHERE TJ001>:P1adoquery里有一个参数P1,赋值以后,为什么adoquery1.open时说参数不对,或信息不完整 ,但是单独用union两连的任何一个语句都 没有问题
请高手指点迷津
SELECT * FROM DEMO..COPTJ where TJ001>=:P1 UNION all SELECT * FROM SLJX..COPTJ WHERE TJ001>:P1adoquery里有一个参数P1,赋值以后,为什么adoquery1.open时说参数不对,或信息不完整 ,但是单独用union两连的任何一个语句都 没有问题
请高手指点迷津
SELECT * FROM DEMO..COPTJ where TJ001>=:P1 UNION all SELECT * FROM SLJX..COPTJ WHERE TJ001>:P2
Declare @p1 as varchar(20)
Set @p1=:p1
SELECT * FROM DEMO..COPTJ where TJ001>=@p1 UNION all SELECT * FROM SLJX..COPTJ WHERE TJ001>@p1