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".

• User-defined scalar functions
• Table-valued functions

SQL Server Builtin Functions - Functions

ELINQ offers all of these as a local class library.

• Aggregate Functions
• Date Functions
• String Functions
• Window Functions

This list is available from the top right Functions menu on the tutorial site

Error Handling

http://www.sommarskog.se/error-handling-I.html

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-III.html

http://www.sommarskog.se/error_handling/Part1.html

http://www.sommarskog.se/error_handling/Part2.html

http://www.sommarskog.se/error_handling/Part3.html

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

http://www.sommarskog.se/error-handling-II.html#cursors

Error Handling In Transaction

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms175976(v=sql.90)?redirectedfrom=MSDN

CTE

https://stackoverflow.com/questions/4740748/when-to-use-common-table-expression-cte

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms190766(v=sql.105)

• 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.