For insert
Create Proc sp_Insert
(
@Name varchar(30),
@Lastname varchar(30),
@Age int
)
as
INSERT INTO TBL_USERS(NAME,LASTNAME,AGE)
VALUES(@NAME,@LASTNAME,@AGE)
For Update
Create Proc sp_Update
(
@Name varchar(30),
@Lastname varchar(30),
@Age int
)
as
UPDATE TBL_USERS
SET NAME = @NAME , LASTNAME =@LASTNAME ,AGE =@AGE
You can choose to add a where Clause to make it more Specific
For Delete
Create Proc sp_Delete
(
@Name varchar(30),
@AGE INT
)
as
DELETE TBL_USERS
WHERE NAME = @NAME
AND AGE =@AGE
Thank you for posting at DotnetFunda
Vuyiswa Maseko
Thank you for posting at Dotnetfunda
[Administrator]
Dotnetfundakumar, if this helps please login to Mark As Answer. | Alert Moderator