Multiple Select Query: Heidi Uses First Table Name for All Results

SARNOLD-KIT posted 2 years ago in General

Please see attached screenshot;

1 attachment(s):
  • heidi-results-bug
ansgar posted 2 years ago

You need to separate the queries with semicolon, so HeidiSQL can find the right table name in them.

kalvaro posted 2 years ago

I presume you are using SQL Server. FYI, not using statement delimiter is apparently deprecated and will be removed in some to-be-determined future version:

The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed in a later version. The specific version of SQL Server has not been determined.


Not ending Transact-SQL statements with a semicolon.

Please login to leave a reply, or register at first.