I have 2 queries and the results show in 2 tabs, as you can see in the screenshot. But all the tabs have the same name, which is deduced from the first query's table name.
Multiple resultsets' names in tabs
Works for me, on MSSQL. See attachment.
I cannot see why that should not work for someone else on the latest builds. See this thread for details: http://www.heidisql.com/forum.php?t=20979
On MSSQL the semicolon is used to separate batches, so I prefer to leave it out. When I have to files with thousands of statements, eg inserts, I would put a semicolon after every 500th statement.
But otherwise the parser is clever enough to know where the new query starts.
SQL Server used to splits statements by context. The use of semicolons was introduced later (I believe it didn't even exist in earlier versions) and I believe it's now the recommended practice.
There's also the
GO batch separator but strictly speaking it isn't a statement separator.
Well then I see no way of retrieving the right table name for a result in HeidiSQL. For MySQL there are C-API functions, which in MSSQL or the ADODB driver do not provide. So, HeidiSQL parses the SQL queries to find the right table name. When parsing a batch, HeidiSQL relies on the semicolon. I see no way of detecting queries by context, like the MSSQL server does.
Please login to leave a reply, or register at first.