PROCEDURE Add_plan,del_plan,update_plan

 
CREATE PROCEDURE Add_plan
@plan_date varchar(50),
@plan_time varchar(50),
@show varchar(100),
@address varchar(100)
AS
INSERT INTO [plan]
(
plan_date,
plan_time,
show,
address
)
VALUES
(
@plan_date,
@plan_time,
@show,
@address
)
GO

CREATE PROCEDURE del_plan
 @id int
AS
delete from  [plan]
where
 id=@id
GO

CREATE PROCEDURE update_plan
 @id int,
 @plan_date varchar(50),
 @plan_time varchar(50),
 @address varchar(100),
 @show varchar(100)
AS
Update  [plan]
set
 plan_date=@plan_date,
 plan_time=@plan_time,
 address=@address,
 show=@show
where
 id=@id
GO