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

set delimiter

User, date Message
Written by kun6858
2 years ago
Category: Feature discussion
3 posts since Mon, 23 Apr 12
as you already know the character ; is the default delimiter which delimits each SQL query.

but I'd like to set this default to newline character, for instance ("\n") so that i can execute query easily like Toad for oracle.
Written by kun6858
2 years ago
3 posts since Mon, 23 Apr 12
anyone knows about it?
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
You can set the delimiter to anything but a newline charactersmileIndeed, that's a limitation of the DELIMITER command, which needs a new line at the end to recognize the delimiter.
Written by kun6858
2 years ago
3 posts since Mon, 23 Apr 12
unhappyOK, dude. thanks
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
Hm, did you know you can run the current query where the cursor is located, via Shift+Ctrl+F9 . That's probably what you need.
Written by matsg
7 months ago
10 posts since Tue, 24 Jan 12
Follow-up on an old post here, but I just tried setting the delimiter to "go", and unfortunately it matched in the middle of an SQL query, where I created a table called InvoiceCategory. "Cannot create table InvoiceCate", the server responded.

In SQL Server, it is common to create a bunch of statements, delimited with a semicolon, and then use "go" to send it off in one big batch to the server.

I guess this is a bug?
Written by kalvaro
7 months ago
587 posts since Thu, 29 Nov 07
Nope, it's just a different syntax. And, as far as I know, `GO` is not even a standard Transact-SQL feature:

wrote: SQL Server provides commands that are not Transact-SQL statements, but are recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code Editor. These commands can be used to facilitate the readability and execution of batches and scripts.



SQL Server Utilities Statements

(BTW, I've always wanted to report it as feature request for the SQL Server support in HeidiSQL and never found the time.)
Written by matsg
7 months ago
10 posts since Tue, 24 Jan 12
Well, even so, shouldn't I be able to use "go" as a delimiter without it matching in the middle of "InvoiceCategory"?
 

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