Add a stored procedure in SSDT
By: Armando Prato
We've created a table and we could use a stored procedure to access any data that gets added to the table.
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.