Alter and create procedure

Kannav Jamwal

9y957

Hi folks,

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hariharan Krishnamoorthi9y ago
Creating a new procedure is called Create.
Altering already existing procedure is called Alter.
0
Dharmraj Thakur9y ago
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....
0
Rafnas T P9y ago
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
0
Manas Mohapatra9y ago
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
-1