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