如下语句,
select name from where id=:aa
union
select name from where id=:aa在用TADODataSet时则参数被要求为两个相同参数。能不能只用一个参数,否则SQL2000下只能declare @aa VarChar(10)
set @aa=:aa
select name from where id=@aa
union
select name from where id=@aa在Oracle下又更加麻烦。能不能将这种情况下TADODataSet两个参数同名参数合并成一个?
select name from where id=:aa
union
select name from where id=:aa在用TADODataSet时则参数被要求为两个相同参数。能不能只用一个参数,否则SQL2000下只能declare @aa VarChar(10)
set @aa=:aa
select name from where id=@aa
union
select name from where id=@aa在Oracle下又更加麻烦。能不能将这种情况下TADODataSet两个参数同名参数合并成一个?
select name from
(select name from
union
select name from ) a where id=:a