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)
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
No comments:
Post a Comment