"SQL Server Name Convention and T-SQL Programming Style" suggestions

[IanKemp]

"SQL Server Name Convention and T-SQL Programming Style" suggestions

[ktaranov]

Hi, Ian. Great thanks for your suggestions.

Nothing about unique indexes, do they fall under standard non-clustered?

See this row in SQL Server Object Name Convention table (first table)

Table Unique (Alternative) Key	UQ	PascalCase	128	No	AK_	No	Yes	[A-z][0-9]	AK_MyTable_MyColumn_AnotherColumn

"Exact Numerics", "bigint" - "what use" column seems incomplete

Agree, I will fix it tomorrow

I was under the impression that the recommended way to name aliases (and in fact anything) in T-SQL was to use square brackets, i.e.:

We use " because it ANSI standard and works in any relation database, you can modify this template for you needs.

Example sproc uses create...alter but since SQL 2016 you can use create or alter, consider either updating the example or adding a note.

Agree, I will update it tomorrow.

... except the sproc example given above does use exec.

Could you provide more details about this suggestion?

[stephenjesus]

Hi guys, Try this free SQL Formatter online
SQL Fomatter Online

[ktaranov]

Updated via ed1d9b6