Naming Convention

APX1088 – Parameters names not specified explicitly

Description:

This rule evaluates the T-SQL script for executing a stored procedure without referencing parameters explicitly by name.

Although it is possible, it is considered a best practice to provide the names of the parameters.

For more information visit

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/execute-a-stored-procedure?view=sql-server-2017

Example script:

Message:

Explicitly named parameters not used when calling procedure,proc_ListAllParam

APX1110 – Special chars in name

Description:

This rule evaluates the T-SQL script for using special characters in identifiers.

Try to avoid using special characters in the identifiers.

For more information visit

https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md

Example script:

Message:

Special character detected in identifier, [First’Last]

APX1155 – Naming convention prefix

Description:

This rule evaluates the T-SQL script for using object type prefixes in object names. e.g. sp_, trg_, fn_ etc.

For more information visit

https://solutioncenter.apexsql.com/rules-of-sql-formatting-sql-naming-conventions-and-capitalization-rules/

Example script:

Message:

Object type prefix, ‘*’, detected

SQLShack

SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members
SQLShack

Latest posts by SQLShack (see all)