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