forum

Home / DeveloperSection / Forums / How to Create a Common Stored Procedure For Insert Update and Delete ?

Ask Question
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

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

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

Liked By