T-SQL Programming and Scripting For SQL DBA and Developer

Learn how to use T-SQL variables in SQL Server, including local and global variables, declare with @, set or select to assign values, and print results via AdventureWorks examples.

This lecture introduces the SQL Server waitfor command, showing how to pause execution with wait for time or wait for delay in stored procedures and jobs.

Master the while loop in SQL Server, using break and continue to control iteration, and apply practical T-SQL scripting techniques discussed in the course.

Learn to build two dependent T-SQL jobs in SQL Server Agent: start a backup script, wait for it to finish using sp_start_job and job history, then trigger the cleanup job.

Generate a script to change the database owner to sa across multiple databases. Filter online databases where the owner is not sa and apply the change with alter authorization.

Generate a script to change the recovery model for multiple databases in SQL Server, using print statements and a where clause to exclude system databases.

Learn SQL Server error handling with try/catch, throw, and raiserror. Enforce rules and log errors by displaying messages when salaries exceed set limits.

Understand set xact abort and exit abort in t-sql, and how runtime errors roll back the entire transaction. See a practical begin transaction, try-catch, and rollback demonstration.