How to Create and Use Stored Procedures in SQL Server.Real-World Examples of SQL Stored Procedure
Don't forget to LIKE 👍, COMMENT 💬, and SUBSCRIBE 🔔 for more SQL tutorials!
CREATE PROCEDURE GetDepartmentsByGroup
@GroupName NVARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;
SELECT DepartmentID, Name, GroupName, ModifiedDate
FROM AdventureWorks2022.HumanResources.Department
WHERE GroupName = @GroupName;
END;