Using SQL Server Management Studio

1. In Object Explorer, connect to an instance of Database Engine and then expand that instance.
2. Expand Databases, expand the AdventureWorks2022 database, and then expand Programmability.
3. Right-click Stored Procedures, and then click New Stored Procedure.

You will use the syntax to create a simple stored procedure in SQL. But before that, create two tables using the CREATE TABLE command that you will use throughout the article. You will also insert some values in them using the INSERT INTO command.

SQL Server Management Studio is used.
Connect to a Database Engine instance in Object Explorer and then extend that instance.
Expand Databases first, then the AdventureWorks2022 database, and finally Programmability.
Click New Stored Procedure after right-clicking Stored Procedures.