How to Delete and Change a Stored Procedure in SQL

In this article I am going to explain about how to delete or change a stored procedure.
  • 2320

Introduction

In this article I am going to explain about how to delete or change a stored procedure. There are many situations when we need to change or modify a stored procedure. ALTER PROC statement is used to alter any stored procedure. DROP PROC statement is used to delete any stored procedure.

A Statement that create vendors table

van (1).jpg

Statements that insert data in vendors table

van (2).jpg

A Statement that is used to fetch data from vendors table

van.jpg

A Statement that creates a Stored Procedure

Clipboard10.jpg

A Statement that modify Stored Procedure

Clipboard14.jpg

A Statement that run Stored Procedure

Clipboard16.jpg

Clipboard18.jpg

A Statement that delete Stored Procedure vipendra

Clipboard20.jpg

© 2013 dotNetheaven. All rights reserved.