Add a stored procedure in SSDT

Overview

We've created a table and we could use a stored procedure to access any data that gets added to the table.

Explanation

Adding additional objects is just as easy as what we went through to add our table. Let's add a stored procedure to retrieve Team data. In the Solution Explorer, right click on the Futbol project and choose Add->Stored Procedure.

You will be presented with the Add New Item screen where you will name your stored procedure. Name the proc GetTeam and click Add.

Visual Studio will present a .sql script with template code for the stored procedure. I modify the template code and save my changes.

source collected from mssqltips.com