# Stored Procedures in T-SQL

Stored Procedures in T-SQL: Creating Stored Procedures, Calling a Stored Procedure from C#.

Updated: November 3, 2026

1. [Creating Stored Procedures](https://www.ask-codey.com/lessons/stored-procedures-in-t-sql-creating-stored-procedures) (Journeyman): A stored procedure is a named, saved batch of SQL that takes parameters. Create one with CREATE OR ALTER PROCEDURE, give parameters defaults, and run it with EXEC.
2. [Calling a Stored Procedure from C#](https://www.ask-codey.com/lessons/stored-procedures-in-t-sql-calling-a-stored-procedure-from-csharp) (Journeyman): In ADO.NET, put the procedure's name in a SqlCommand, set its CommandType to StoredProcedure, and add each parameter by name. Then read the results as from any query.

Source: https://www.ask-codey.com/courses/csharp-full-stack-bootcamp/topics/stored-procedures-in-t-sql