distal-attribute
distal-attribute
distal-attribute
distal-attribute

can't recognize go commands?

User, date Message
Written by reubendevries
3 weeks ago
Category: Running SQL scripts
1 posts since Sun, 29 Jun 14
It seems like when I run batch of commands that HeidiSQL doesn't like my Go command in between, but when I manually try with MS SQL Management 2012 it works. Has anyone else come across this issue.
Written by kalvaro
3 weeks ago
587 posts since Thu, 29 Nov 07
GO is a command from the SQLCMD utility that's also understood by SQL Server Management Studio. While it isn't strictly SQL I think it'd be a sensible feature request for HeidiSQL since it's very common in SQL Server scripts so I've opened a ticket in case the developer(s) can spare some time:

http://code.google.com/p/heidisql/issues/detail?id=3600

Feel free to comment into the ticket. I've never used GO with the optional parameter (in fact, I've only used GO so my scripts don't crash in SQLCMD) but it appears to be a batch separator that optionally allows to repeat the execution of last batch. A clear explanation in plain English would be a nice addition.
Written by jfalchMoney, Euro
3 weeks ago
380 posts since Sat, 17 Oct 09
go commands are not a part of sql, and thus not handled by heidisql ; they are only recognized by ms clients (management studio, sqlcmd), as a sort of processing instruction (take everything i have input so far and process it now).
Written by kalvaro
3 weeks ago
587 posts since Thu, 29 Nov 07
I still have mixed opinions about how HeidiSQL should deal with it. It's probably crazy to reimplement all the SQLCMD command set but "GO" is fairly common (basically because SQLCMD will not run complex SQL statements without it). Ignoring it can be simple but might lead to wrong expectations.
 

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