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: 4310 | Views in the last 30 days: 1
Related Articles

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 ...


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


Semicolon in T-SQL

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


XML parsing: semicolon expected

I know the "XML parsing: semicolon expected" error is a data error, and not a SQL error.  The first ...


semicolon statement terminator

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