A problem about ADO!

i visit db with ado interface, but now i hava a sql like below:

select * into #t1 from measureInfo; select * from #t1; drop table #t1;

it can't execute with ado. Does Ado not support sql operation like this?

thks

Yes.. You can do this...execute the below query it will work..

Set NOCOUNT ON;select * into #t1 from measureInfo; select * from #t1; drop table #t1;