One SP for all

Question

Hi, I need a single stored procedure to be used for select, insert, delete and update . Thanks in advance.

Manish Kumar Choudhary · Answer

Hi sathish , Alter PROCEDURE MasterInsertUpdateDelete ( @id INTEGER , @first_name VARCHAR ( 10 ), @last_name VARCHAR ( 10 ), @salary DECIMAL ( 10 , 2 ), @city VARCHAR ( 20 ), @StatementType nvarchar ( 20 ) = '' ) AS BEGIN IF @StatementType = 'Insert' BEGIN insert into employee ( id , first_name , last_name , salary , city ) values ( @id , @first_name , @last_name , @salary , @city ) END IF @StatementType = 'Select' BEGIN select * from employee END IF @StatementType = 'Update' BEGIN UPDATE employee SET First_name = @first_name , last_name = @last_name , salary = @salary , city = @city WHERE id = @id END else IF @StatementType = 'Delete' BEGIN DELETE FROM employee WHERE id = @id END end

Stavri · Answer

Hi Sathish, You can read about the solution of your task in the article entitled "Select, Insert, Update, Delete Using Stored Procedure in SQL Server 2008" that is written by Rohatash Kumar. The article which is accompanied by a practical example is accessible here: http://www.c-sharpcorner.com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/ Best regards, Stavri

One SP for all

Answers (2)