Includes an example that uses the AdventureWorks database, which has a Sales.Currency table with an UPDATE trigger. The sample includes a stored procedure that updates a row in the table, thus causing the trigger to fire.
Provides an example that uses an existing User Defined Function (UDF) in the AdventureWorks database, named ufnGetStock that returns a count of items in stock for a given ProductID. It illustrates jumping from one T-SQL object (the stored procedure) to another (the function).
Shows how to debug a SQL CLR trigger. It uses the Contact table in the AdventureWorks sample database, which is one of the databases installed with SQL Server 2005. The sample creates a new insert CLR trigger on the Contact table, and then steps into it.
Shows how to debug a CLR SQL user-defined aggregate. It creates a new CLR SQL aggregate function named Concatenate in the Adventureworks sample database. When this function is invoked in a SQL statement, it will concatenate together all the values for the column specified as its input parameter.
Shows how to debug a SQL/CLR user-defined type. It creates a new SQL/CLR type in the Adventureworks sample database. The type is then used in a table definition, an INSERT statement, and then a SELECT statement.