Re: [Squirrel-sql-users] multi-statement SQL statements

[Colin B. <col...@te...>]

> From: Neville Rowe <Nev...@dr...>
> Date: Wednesday, November 19, 2003 11:15 pm
> Subject: [Squirrel-sql-users] multi-statement SQL statements

> I hope I'm not barking up the wrong tree here.
> 
> SquirrelSQL has always had problems for me with multiple 
> statements - e.g.
> select * into #tmp1 from table1
> select * from #tmp1
> where there may be (multiple) results sets interspersed with 
> (multiple) 
> update counts.

Can you give me some details about the problems you're having? The following SQL

select * into #tmp1 from authors;
select * from #tmp1

when executed gives me the following msgs:

23 Rows Updated
Query 1 elapsed time (seconds) - Total: 0.031, SQL query: 0.031, Building output: 0
Query 2 elapsed time (seconds) - Total: 0.594, SQL query: 0.031, Building output: 0.563

which seems to be correct to me.

This is using Microsoft SQL server 7.0

--
Colin Bell
http://squirrel-sql.sf.net