SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Prompt Tips #6 - Insert Semicolons

By Steve Jones, (first published: 2015/01/20)

One of the more exciting new features in SQL Prompt v6.4 is the ability to add semi colons to your code. T-SQL added semicolons as optional terminators in the language, though there are a few places where the previous statement must be terminated with a semicolon for your code to parse.

As developers slowly begin to add semicolons to their code, we find that many people forget to add them as they write code and either must add them later or leave them out. 

SQL Prompt will add those semicolons for you if you use this quick shortcut: CTRL+B, C. This means hold the Control key, then press the  B, then press the C.

You can see a quick video of this tip below:

 
Total article views: 4303 | Views in the last 30 days: 2
 
Related Articles
ARTICLE

The GO Command and the Semicolon Terminator

There are probably not many SQL Server DBAs that use the semicolon as a statement separator. In SQL ...

FORUM

How to save data from a semicolon delimited file?

Saving data from semicolon delimited file (CDR) to MS SQL Server 2005 using Bulk Insert And BCP 9

FORUM

Semicolon in T-SQL

Is it considered good practice to end your T-SQL statements with a semicolon? SELECT * FROM Prac...

FORUM

semicolon statement terminator

Is it possible to disable the semicolon (;) separator (i.e. disable the use of multiple SQL statemen...

FORUM

Separating Semicolon Separated Fields

Hey, I have a flat file with 2 columns in it. an Identity field and a semicolon separated field ...

Tags
 
Contribute