delete_stu.sql

图书馆系统建立

create procedure delete_stu
(@stu_id int)
as 
if @stu_id is  null
begin
print '输入学号'
return -10
end
delete from stu_info where stu_id=@stu_id
RETURN 0