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.