student.sql

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

declare @s_id int
declare @s_name varchar(8)
declare @s_class_id int
declare @s_sex tinyint
declare @s_birthday datetime
declare @s_nationality varchar(20)
declare @s_nativeplace varchar(20)
declare @s_address varchar(60)
declare @s_zip varchar(6)
declare @s_phone varchar(25)
declare @s_sfzh varchar(50)
declare @s_memo varchar(100)

set @s_id =1
set @s_class_id = @s_id % 70 + 1
set @s_sex = @s_id % 2 
set @s_nativeplace = @s_id % 100 + 1
set @s_memo = @s_id % 4 + 1
set @s_sfzh = 330724198606161000 + @s_id
use xsgl
delete from student
while @s_id <= 1000
begin
    insert into student
    values (@s_id,'张'+ convert(varchar(8),@s_id),@s_class_id,@s_sex,'1986-9-6','ldf','籍贯'+ convert(varchar(20),@s_nativeplace),'kldf','321568','df',@s_sfzh,@s_memo)
    set @s_id = @s_id + 1
    set @s_class_id = @s_id % 70 + 1
set @s_sex = @s_id % 2 
set @s_nativeplace = @s_id % 100 + 1
set @s_memo = @s_id % 4 + 1
set @s_sfzh = 330724198606161000 + @s_id
end