SQL Server Stored Procedure - DELETE - Example

Source code to create and add sql delete stored procedure to catalog

The following example is for creating a simple delete stored procedure. You can run it through an explicit call from a host language program or directly from a DBMS query execution shell like SQL Server Management Studio or dbOrchestra.

IF ( OBJECT_ID('dbo.sp_Students_DEL_byPK') IS NOT NULL ) 
   DROP PROCEDURE dbo.sp_Students_DEL_byPK
GO

CREATE PROCEDURE dbo.sp_Students_DEL_byPK
       @student_id    INT        
AS 
BEGIN 
     SET NOCOUNT ON 

     DELETE dbo.Students
     FROM   dbo.Students
     WHERE  
            student_id = @student_id

END

GO

Executing the sql delete stored procedure

Execute sql delete stored procedure

To run the stored procedure you need to supply a values to the applicable variables.

-- @student_id  IN  INT

EXEC dbo.sp_Students_DEL_byPK
     @student_id  =  25    

GO

Link to schema for Students table

If you find this site useful and are a book buyer/reader... You can support my site by clicking on one of the Links below to Abe books By doing this, I will receive a small commision on your purchase and making your purchase will not cost you any more money than if you went directly the site yourself! Abe Books sells books at a fraction of the original cost. I have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars including shipping costs Click on applicable icon to find books at Abe Books on ...
SQL Server 2008	SQL Server 2005	SQL Server 2000	T-SQL

Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. If it is printed they likely have a copy. I have also included a generic link to Abe Books below. Once on their site, you will find that they have a nice, easy to use search engine so to find what you are looking for.