--用储存过程实现对数据库表的增 删 改 --wuyisky
create table proceduretest --创建表
([id] int,
[name] varchar(100),
age int,
brithday Datetime
)
select * from proceduretest --查询
create procedure dt_Addprocedure --创建增加记录的储存过程
@id int,
@name varchar(100),
@age int,
@brithday Datetime
as
insert into proceduretest([id],[name],age,brithday) values(@id,@name,@age,@brithday)
create procedure dt_UpdateProcedure --创建修改记录的储存过程
@id int,
@name varchar(100),
@age int,
@brithday Datetime
as
update proceduretest set [name]=@name,age=@age,brithday=@brithday where [id]=@id
create procedure dt_delProcedure --创建删除记录的储存过程
@id int
as delete proceduretest where [id]=@id
dt_addprocedure 100,'wuyisky',24,'1984-06-13' --用储存过程增加一条记录
select * from proceduretest --查询
dt_UpdateProcedure 100,'wuyi',24,'1984-10-19' --修改记录
dt_delProcedure 100 --删除记录
select * from proceduretest --查询 wuyisky于2007年5月30日