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

Question

Anonymous User · Answer

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 andgt; 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

forum

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

Anonymous User

Can you answer this question?

1 Answers

Liked By