class.sql

学生基本信息管理系统 学生基本信息管理系统 学生基本信息管理系统 学生基本信息管理系统

declare @c_id int
declare @c_name varchar(40)
declare @c_speciality_id int
declare @c_departno_id int
declare @c_stainf_id int
declare @c_memo varchar(10)
set @c_id = 1
set @c_speciality_id = @c_id % 20 + 1
set @c_departno_id = @c_id % 4 + 1
set @c_stainf_id = @c_id % 15 + 1
set @c_memo = @c_id % 2 + 1
use xsgl
delete from class
while @c_id <= 70
begin
    insert into class
    values (@c_id,'班级'+ convert(varchar(40),@c_id),@c_speciality_id,@c_departno_id,@c_stainf_id,@c_memo)
    set @c_id = @c_id + 1
    set @c_speciality_id = @c_id % 20 + 1
    set @c_departno_id = @c_id % 4 + 1
    set @c_stainf_id = @c_id % 15 + 1
    set @c_memo = @c_id % 2 + 1
end