User[(pk)Id int ;name char(4);age int ]
--添加數據
create procedure p_Insert_UserData
@iID int,
@cName char(4),
@iAge int
as
insert into User
values(@iID,@cName,@iAge)
go
--更新數據
create procedure p_Update_UserData
@iID int,
@cName char(4),
@iAge int
as
update User
set name=@cName,age=@iAge
where id=@iID
go