添加

--添加
create proc p_Add
(
@Name varchar(50),
@Age varchar(50),
@Sex varchar(20),
@StatId int
)
as
begin
insert into Stu values(@Name,@Age,@Sex,@StatId)
end

--测试
exec p_Add '小虎','6','男',16

select * from Stu