# SQL Server Rule: SRD0068
| | |
|----|----|
| Assembly | SqlServer.Rules |
| Namespace | SqlServer.Rules.Design |
| Class | SemicolonTerminationRule |
## Rule Information
| | |
|----|----|
| Id | SRD0068 |
| Friendly Name | Terminate statements with semicolon. |
| Category | Design |
| Ignorable | true |
| Applicable Types | Procedure |
| | Scalar Function |
| | Table Valued Function |
| | View |
## Description
Query statements should finish with a semicolon - ';'.
## Summary
Terminate statements with semicolon to follow Microsoft guidelines.
### Examples
```sql
CREATE PROCEDURE dbo.Test1
AS
SET NOCOUNT ON
SELECT FOO FROM BAR --violation
BEGIN TRY;
SELECT 1 --violation
END TRY
BEGIN CATCH;
SELECT 2;
END CATCH --violation
CREATE TABLE t1 (
ColumnOne int,
INDEX IX_ColumnOne NONCLUSTERED (ColumnOne)) --violation
CREATE INDEX i1 ON t1 (col1) --violation
IF NOT EXISTS(SELECT * FROM SYS.INDEXES WHERE OBJECT_ID = OBJECT_ID('dbo.Foo') AND [name] = 'IX_FooIndex')
BEGIN;
CREATE UNIQUE NONCLUSTERED INDEX IX_FooIndex ON dbo.Foo(Name)
WITH(DATA_COMPRESSION = PAGE, ONLINE = ON) -- violation
END;
IF NOT EXISTS(SELECT * FROM SYS.INDEXES WHERE OBJECT_ID = OBJECT_ID('dbo.Foo'))
BEGIN
SELECT 1;
END
BEGIN
RECEIVE TOP (1) * FROM ExpenseQueue --violation
END
GO
CREATE VIEW [foo].[bar] AS
SELECT a, b FROM foo.baz -- violation
GO
CREATE FUNCTION dbo.SelectReturnTypeFunction ()
RETURNS TABLE
AS
RETURN
(
WITH cte AS
(
SELECT c1, c2 FROM t1
)
SELECT c1, c2 FROM cte -- should not trigger an error
) -- violation
GO
-- SRD0068
```
<sub><sup>Generated by a tool</sup></sub>
