SQL SERVER – Guidelines and Coding Standards Complete List Download

Feeds:: Posts; Comments

SQL SERVER – Guidelines and Coding Standards Complete List Download

September 25, 2008 by pinaldave

SQL SERVER – Guidelines and Coding Standards complete List Download

Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where they should not prevent best practices for coding. They are basically the guidelines that one should follow for better understanding.

The concept behind implementing coding standards and guidelines, is that the consistency and uniformity in programming so that if multiple people are working on the same code, it becomes easier to communicate, share with or understand each other’s work.

With the goal of promoting good coding standards and guidelines I have created document which can guide developers.

SQL SERVER – Guidelines and Coding Standards Part – 1

SQL SERVER – Guidelines and Coding Standards Part – 2

SQL SERVER – Guidelines and Coding Standards complete List Download

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Posted in Best Practices, DBA, Data Warehousing, Database, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Documentation, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, SQLAuthority, T SQL, Technology | 5 Comments

5 Responses

on September 25, 2008 at 3:32 pm Richard

Hi,
the direct links to part 1 & 2 above both have typos

SQL SERVER – Guidelines and Coding Standards Part – 1
Should be http://blog.sqlauthority.com/2008/09/23/sql-server-coding-standards-guidelines-part-1/
(Not 09/22)

SQL SERVER – Guidelines and Coding Standards Part – 2
Should be http://blog.sqlauthority.com/2008/09/24/sql-server-coding-standards-guidelines-part-2/
(Not 09/23)
on September 26, 2008 at 3:12 pm Surendar

Hello Dave,

I’m having two tables

Table1: Table2:

ID Date Month Jan Feb Mar Remarks

1 1 Jan xx xx xx xxxxx

2 14 Jan xx xx xx xxxxx

3 26 Jan xx xx xx xxxxx

4 14 Feb xx xx xx xxxxx

5 13 Mar

I want distinct values of Month in Table1 to be the Column Name of Table2 as above said:
can you help me out

Thanks & Regards
Surendar K
on September 26, 2008 at 3:21 pm Surendar

Hello Dave,

I want distinct values of Month in Table1 to be the Column Name of Table2 as below dynamically

Table1:

ID Date Month

1 1 Jan

2 14 Jan

3 26 Jan

4 14 Feb

5 13 Mar

Table2:

Jan Feb Mar Remarks

Thanks & Regards
Surendar K
on May 17, 2009 at 3:41 pm ashish

hi..
i want count all rows with group by and also count some specific rows with same group by statement.

department total_Emp waitng_list Joind_Emp
—————————————————————————
ABCD 50 10 40
CDEF 20 10 10
on May 18, 2009 at 9:23 pm dhandapani

i want need how to change to password in sql server 2005 to run vb 6.0.

my project not connection to change password in sql server 2005 not run in visual basic 6.0