insert_stu.sql

图书馆系统建立

create procedure insert_stu
(@stu_id int,@stu_name char(8),@sex_id int,@spe_id char(50),@stu_date smalldatetime ,@stu_state_id int,@stu_edu char(40))
AS
insert into stu_info values('@stu_id','@stu_name','@sex_id','@spe_id','@stu_date ,'@stu_state_id','@stu_edu' )
RETURN 0