Transact SQL Coding Techniques

http://www.toadworld.com/platforms/sql-server/w/wiki/10086.transact-sql-coding-techniques.aspx

Transact SQL Coding Techniques

Welcome to the Transact-SQL Coding Techniques section. This section of the wiki is for developers (whether they're using T-SQL, C#, VB.net, or any number of languages) who need to write T-SQL code for development.

The navigation below is forked into "just make it work" and "show me the details" but there will be many cross-linked pages (ah, the power of the Internet).

T-SQL Problem Solving (just make it work)

• Management Trees
• Deployment Scripting

T-SQL Code Components (show me the details)

Here are some common T-SQL code components:

• Collation
• Common Table Expressions
• Cursors
• Data Types
• DBCC Commands
• Error Handling
• Functions
• Identifiers & Literals
• Identities
• Joins
• Loops & Conditional Processing
• Select Modifiers - like Distinct and Union.
• Stored Procedures
• Temporary Objects
• Transactions and Locking
• Triggers
• Views
• Variables & Parameters
• XML