Aug 29, 2010 · The naming conventions used in SQL Server's AdventureWorks database demonstrate many best practices in terms of style. To summarize: Object names are easily understood; Table names are not pluralized ("User" table not "Users") Abbreviations are few, but allowed (i.e. Qty, Amt, etc.)

Feb 7, 2009 · Wouldn't call it coding standard - more like coding style. SELECT T1.col1, T1.col2, T2.col3 FROM table1 T1 INNER JOIN ON Table2 T2 ON T1.ID = T2.ID WHERE T1.col1 = 'xxx' AND T2.Col3 = 'yyy' capitalize reserved words; main keywords on new line; can't get used to commas before columns; always use short meaningful table aliases

Here are some SQL programming guidelines and best practices we collected: Do not use SELECT * in your queries. Always use table aliases when your SQL statement involves more than one source. Use the more readable ANSI-Standard Join clauses instead of the old style joins. Do not use column numbers in the ORDER BY clause.

I've been writing SQL for a number of years now on various DBMS (Oracle, SQL Server, MySQL, Access etc.) and one thing that has always struck me is the seemingly lack of naming convention when it comes to table & sub-query aliases.

Oct 28, 2011 · There are seemingly a lot of very diversive naming convention recommendations for sql server objects. I was wondering if there are some formal guidelines other than not prefixing stored procedures ...

Aug 10, 2012 · There are plenty of well designed naming conventions on internet. Just search Google on "SQL naming conventions". In my experience people use totally different styles, but it's OK as long as whole application (or all projects in same organization) use the same conventions.

Apr 12, 2011 · Here's some clarification about the sp_ prefix issue in SQL Server. Stored procedures named with the prefix sp_ are system sprocs stored in the Master database. If you give your sproc this prefix, SQL Server looks for them in the Master database first, then the context database, thus unnecessarily wasting resources.

It seems like its going in the direction of plural table names especially since all the system tables in SQL Server are all plural, and the default for Entity Framework is plural out of the box. If that's Microsoft's stance, I want to go the direction where we will be in 20 years. Even Oracle's database conventions say plural table names.

Feb 6, 2009 · In my last job, we worked on a very database-heavy application, and I developed some formatting standards so that we would all write SQL with a common layout. We also developed coding standards, but these are more platform-specific so I'll not go into them here. I'm interested to know what other people use for SQL formatting standards.

Nov 21, 2017 · There is no single Microsoft SQL Server naming convention or standard. You will find that different conventions are in use in different places. What is important is that your code can be understood in the environment where you work. If your workplace has an accepted standard then that seems like the one to use.