Alter and create procedure

Question

Hi folks, Can you please explain the real difference b/w alter and create procedure in a lay man language.

Dharmraj Thakur · Answer

If stored procedure not exists means you are creting first time then you have to write create otherwise you have to use alter means modifying th stored procedure....

Rafnas T P · Answer

Create Procedure is used to creating a new procedure after creating procedure, if you wanted to change then you cant use Create Procedure. if you use create procedure for altering then you will get an error There is already an object, so you have to use Alter Procedure to modify this is the main difference

Hariharan Krishnamoorthi · Answer

Creating a new procedure is called Create. Altering already existing procedure is called Alter.

Manas Mohapatra · Answer

CREATE Creates a Transact-SQL or common language runtime (CLR) stored procedure in SQL Server database. Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch. Contain programming statements that perform operations in the database, including calling other procedures. Return a status value to a calling procedure or batch to indicate success or failure (and the reason for failure). CREATE PROCEDURE uspVendorAllInfo @Product varchar (25) AS SET NOCOUNT ON ; SELECT LEFT (v. Name , 25) AS Vendor FROM tablTemp; ALTER Modifies a previously created procedure that was created by executing the CREATE PROCEDURE statement in SQL Server. For instance, you already created above Stored procedure and you want to add new column(see yellow marked) then ALTER command will help to update the StoredProcedure. ALTER PROCEDURE uspVendorAllInfo @Product varchar (25) AS SET NOCOUNT ON ; SELECT LEFT (v. Name , 25) AS Vendor, LEFT (p. Name , 25) AS 'Product name' , FROM tablTemp; GO

Alter and create procedure

Answers (4)