Description

In SQL Server 2008 R2 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects include stored procedures, functions, and triggers (based on either DML or DDL statements). SQL Server 2008 R2 provides integration with Common-runtime language (CLR). This enables a developer to create programming objects using any of the Microsoft .NET Framework languages and then deploy them within SQL Server using assemblies. This course demonstrates how to create user-defined functions, DML and DDL triggers, and stored procedures, as well as how to use the control of flow language in transactions and handle any errors that might arise within them using TRY…CATCH, RAISERROR, and @@ERROR. The course also demonstrates how to use CLR integration in SQL Server 2008 by deploying CLR code into SQL Server. This course is one of a series in the Algeo learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.