How to Create Update Insert Delete Edit Store Procedure in SQL Server

create table Employee ( EId int primary key identity, EName varchar(50), EAdress varchar(50), EMob int ) Create PROCEDURE Employee_Grid As Begin Select * from Employee End Create procedure Employeee_Insert @EName varchar(50), @EAddress varchar(50), @Emob int AS BEGIN INSERT INTO Employee(EName,EAdress,EMob) values(@EName,@EAddress,@Emob) END Create Procedure Employee_Delete @EID int AS BEGIN DELETE FROM Employee WHERE EId = @EID; END Create Procedure Employee_Edit @EID int As Begin Select * from Employee where EId = @EID; End Create Procedure Employee_Update @EId int, @EName varchar(50), @EAddress varchar(50), @Emob int As Begin Update Employee Set EName = @EName, EAdress = @EAddress, EMob = @Emob where EId = @EId End

0 Comments