Add a stored procedure in SSDT



By:

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.

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

Last Update: 7/22/2014






Comments For This Article





download








get free sql tips
agree to terms