Add a stored procedure in SSDT


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.

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.

Add GetTeam Procedure

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

Save GetTeam Changes

Comments For This Article

get free sql tips
agree to terms