When should I use semicolons in SQL Server?

by

From a SQLServerCentral.Com article by Ken Powers:

The Semicolon

The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard, but was never used within Transact-SQL. Indeed, it was possible to code T-SQL for years without ever encountering a semicolon.

Usage

There are two situations in which you must use the semicolon. The first situation is where you use a Common Table Expression (CTE), and the CTE is not the first statement in the batch. The second is where you issue a Service Broker statement and the Service Broker statement is not the first statement in the batch.

More Related Contents:

  1. Comma separated results in SQL
  2. T-SQL stored procedure that accepts multiple Id values
  3. Understanding PIVOT function in T-SQL
  4. How to get Time from DateTime format in SQL?
  5. Parse JSON in TSQL
  6. Get size of all tables in database
  7. Fuzzy matching using T-SQL
  8. List of all index & index columns in SQL Server DB
  9. Why use a READ UNCOMMITTED isolation level?
  10. Replace duplicate spaces with a single space in T-SQL
  11. How much size “Null” value takes in SQL Server
  12. SQL Server: Isolation level leaks across pooled connections
  13. How do I use the CONCAT function in SQL Server 2008 R2?
  14. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  15. How do I exclude Weekend days in a SQL Server query?
  16. EXEC sp_executesql with multiple parameters
  17. Preserving ORDER BY in SELECT INTO
  18. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  19. Can you call a webservice from TSQL code?
  20. How to add custom attributes to SQL connection string?
  21. Multiple Column Pivot in T-SQL
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. Compute MD5 hash of a UTF8 string
  25. LPAD in SQL Server 2008
  26. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  27. How do I remove non-breaking spaces from a column in SQL server?
  28. Is there an “IF EXISTS” test for a linked server?
  29. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  30. SQL Server stored procedure return code oddity

Leave a Comment