How to Create a Common Stored Procedure For Insert Update and Delete ?

Anonymous User 1980 31 Jul 2018

1 Answers

Anonymous User 31 Jul 2018

CREATE PROCEDURE MasterInsertUpdateDelete 

( 

			

@ContactID int,						

@Name varchar(50),

@Mobile varchar(50),

@Address varchar(250),

@Query int

)

AS 

BEGIN

IF(@Query = 1)

BEGIN

Insert into Contact

(

Name ,

Mobile ,

Address

)

values

(

@Name ,

@Mobile ,

@Address

)

IF(@@ROWCOUNT > 0)

Begin

Select 'Insert'

End

End

IF(@Query = 2)

Begin

Update Contact

set

Name =@Name ,

Mobile =@Mobile ,

Address = @Address

where ContactID =@ContactID

Select 'Update'

End



IF(@Query = 3)

Begin

Delete from Contact where ContactID =@ContactID

Select 'Deleted'

End



IF(@Query = 4)

Begin

Select * from Contact

End

End



IF(@Query = 5)

Begin

Select * from Contact where ContactID =@ContactID

End

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How to Create a Common Stored Procedure For Insert Update and Delete ?

Can you answer this question?

1 Answers