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. |

|