SQL102
Nesting an Exception
Like just about every other technique in Microsoft SQL you can nest your exception handling. The basic template is: BEGIN TRY BEGIN TRY -- Nested try
microsoft sql
SQL102
DDL Triggers
Introduction OK, we all know that when we create objects in a database, we're using Data Definition Language (DDL) commands. Every time we create an object,
SQL201
Variables And Parameters
Transact SQL (T-SQL) has two main wait of passing data, variables, and parameters. A variable is an object in T-SQL batches and scripts that can old a value.
SQL201
Flow Control
When you want to build more intelligent or more flexible T-SQL scripts, you're going to need to know how to control the flow of the program. You'll need the
SQL201
The Error Severity
Errors can have different levels of severity. Based on this severity, you may wish to handle the error in different ways (see my articles on TRY..CATCH). In
SQL102
Triggers Overview
OK, What do you know about triggers? Did you know you can use them to run a bit of T-SQL on data changes? Those would be called Data Manipulation Language
dba
Reindex All Tables in a Database
I just wanted to share a quick script that I used to help re-index all the tables in my database. If you have any questions about it, please let me know! USE
microsoft sql
Procedural, Transact SQL — Batches
When building solutions in T-SQL, you'll often be asked to generate a change script. This change script is a batch of SQL statements that when executed
microsoft sql
DELETE Triggers
This is the last of my three posts on triggers. We've already covered INSERT and UPDATE TRIGGERS. This time we're doing DELETE triggers. All the same rules
SQL201
Sub Queries With Multiple Levels of Nesting
Let's go back to sub queries for a bit. You can nest a sub query within a sub query. There really is no limit. But in doing so, you really need to make sure
SQL201
Sub Query Fundamentals
Here we are with another sub query post. A sub query is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another sub query
SQL201
The Error Message
When dealing with errors, it's often necessary to log, or pass on errors to your users. In either case, you've already seen how to trap the ERROR_NUMBER. This