Program with Transact-SQL

After completing this module, you will be able to:

• Describe the language elements of T-SQL used for simple programming tasks.
• Describe batches and how they're handled by SQL Server.
• Declare and assign variables and synonyms.
• Use IF and WHILE blocks to control program flow.

After completing this module, you will be able to:

• Return results by executing stored procedures.
• Pass parameters to procedures.
• Create simple stored procedures that encapsulate a SELECT statement.
• Construct and execute dynamic SQL with EXEC and sp_executesql.
• Create simple inline table-valued functions and write queries against them.

After completing this module, you will be able to:

• Raise errors using the RAISERROR statement.
• Raise errors using the THROW statement.
• Use the @@ERROR system variable.
• Create custom errors.
• Create alerts that fire when errors occur.

After completing this module, you will be able to:

• Describe transactions.
• Compare transactions and batches.
• Create and manage transactions.
• Handle errors in transactions.
• Describe concurrency.

• Introduction
• Describe T-SQL for programming
• Describe batches
• Declare and assign variables and synonyms
• Use IF and WHILE blocks to control program flow
• Exercise: Program with T-SQL
• Knowledge check
• Summary

• Introduction
• Call stored procedures
• Pass parameters to stored procedures
• Create a stored procedure
• Use dynamic SQL with EXEC and sp-execute-sql
• Create inline table-valued functions
• Exercise: Create stored procedures and table-valued functions
• Knowledge check
• Summary

• Introduction
• Implement T-SQL error handling
• Implement structured exception handling
• Exercise: Implement error handling with Transact-SQL
• Knowledge check
• Summary

• Introduction
• Describe transactions
• Compare transactions and batches
• Create and manage transactions
• Handle errors in transactions
• Describe concurrency
• Exercise: Implement transactions with Transact-SQL
• Knowledge check
• Summary