D
DBG
Is it possible to batch multiple queries into one pass-through query?
One table is local the other on sql server
ie
Select a.id from table a inner join table b on a.id = b.id where a.timestamp
<> b.timestamp
select a.id from table a inner join table b on a.id = b.id where a.id is null
select a.id from table a inner join table b on a.id = b.id where b.id is null
to get all record ids on the server which are new, deleted, changed in one
returned query.
anyone have the syntax if it is possible?
On SQL server I can use a ; to run to queries at once, no so thru a pass
through.
Thanks,
-David
One table is local the other on sql server
ie
Select a.id from table a inner join table b on a.id = b.id where a.timestamp
<> b.timestamp
select a.id from table a inner join table b on a.id = b.id where a.id is null
select a.id from table a inner join table b on a.id = b.id where b.id is null
to get all record ids on the server which are new, deleted, changed in one
returned query.
anyone have the syntax if it is possible?
On SQL server I can use a ; to run to queries at once, no so thru a pass
through.
Thanks,
-David