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

Michael Lato, Transact SQL Coding Techniques Editor

Michael Lato

Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael's past roles have been as diverse as system designer, project manager and head trainer. He is currently the senior SQL Server database developer and DBA for an international semiconductor company.

His online presences include:

• Email: michael.lato@datatamer.ca
• Website: http://www.datatamer.ca
• Blog: http://datatamer.blogspot.com