Coding standards and guidelines are very important for any developer on the path to a 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.
SQL SERVER – Guidelines and Coding Standards Part – 2
To express apostrophe within a string, nest single quotes (two single quotes). Example: SET @sExample = 'SQL''s Authority' When working with branch conditions or complicated expressions, use parenthesis to increase readability. IF ((SELECT 1 FROM TableName WHERE 1=2) ISNULL) To mark a single line as comment use (–) before the statement.…
Read MoreSQL SERVER – Guidelines and Coding Standards Part – 1
Use “Pascal” notation for SQL server Objects Like Tables, Views, Stored Procedures. Also tables and views should have ending “s”. Example: UserDetails Emails If you have big subset of table group than it makes sense to give prefix for this table group. Prefix should be separated by _. Example: Page_…
Read MoreSQLAuthority News – 700 Articles and Author Updates
It is always interested to write article when reached at milestone. I start to receive many emails and suggestions just about when this blog is reaching any milestone. One question keep on coming to me is why do I write or what is in it for me? Satisfaction! I enjoy…
Read MoreSQL SERVER – XML – Split a Delimited String – Generate a Delimited String
SQL Server MVP and my very good friend Jacob Sebastian has written two wonderful articles about SQL Server and XML. I encourage to read this two articles to anybody who are interested in learning SQL and XML. Let us see how to Split a Delimited String.
SQLAuthority News – Tip of the Minute
Since my new personal website is launched I have received many comments and emails regarding new section of Tip of the Minute. Right navigation bar of the my personal website https://www.pinaldave.com/ contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip…
Read MoreSQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008
Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular among enthusiastic IT professionals. I have joined this group and suggest all the developers of Ahmedabad and surrounding areas to join this group. It does not matter which application you are using but…
Read More