T-SQL 101: 124 Understanding Stored Procedures in SQL Server T-SQL
Stored procedures are prepackaged groups of T-SQL statements. They can also be written in other languages, but most of the time they’ll be written in T-SQL.
There are pros and cons with using stored procedures.
In the example shown, I use the EXEC statement to execute a stored procedure called SDU_Tools.ListAllDataTypesInUse.
Parameters
The procedure also takes a number of parameters. By using different parameters values, I can change the behaviour of the stored procedure.
2025-03-04