Error Handling with Cursor (edit)
SQL Server Tutorial
- Standard (actually most of SQL is here, including many advanced concepts)
- Advanced (User-defined Functions)
- Functions (Builtin Functions)
SQL Server Basics - Standard
- Section 1. Querying data
- Section 2. Sorting data
- Section 3. Limiting rows
- Section 4. Filtering data
- Section 5. Joining tables
- Section 6. Grouping data
- Section 7. Subquery
- Section 8. Set Operators
- Section 9. Common Table Expression (CTE)
- Section 11. Modifying data
SQL Server User-defined Functions - Advanced
We suggest to open the corresponding tutorial page and go over the examples "side by side".
SQL Server Builtin Functions - Functions
ELINQ offers all of these as a local class library.
This list is available from the top right Functions menu on the tutorial site
It written for SQL Server 2000, but it covers the new try/catch error handling abilities in SQL Server 2005+ as well.
Error Handling with Cursor
Error Handling In Transaction
- Combining Results Sets with UNION
Explains how to combine the results of two or more SELECT statements into a single result set.
- Performing Semi-Joins with EXCEPT and INTERSECT
Explains how to compare the results of two or more SELECT statements and return distinct values.
- Using UNION, EXCEPT and INTERSECT with Other Transact-SQL Statements
Provides guidelines for when you use UNION, EXCEPT, and INTERSECT with other Transact-SQL statements.
- Using Common Table Expressions
Explains how to work with table-valued expressions in a query.
- Summarizing Data
Introduces the tools that programmers can use to perform multidimensional analysis of SQL Server data.
- Using Partitioned Views
Introduces the use of views that split data from a large table across one or more servers.
- Using Query Notifications
Explains how to program an application to respond to changes in query results.
- Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS
Explains how to use the ROLLUP, GROUP BY, and GROUPING SETS operators, and provides some examples.