我要评论1.普通循环
create table ws_student
(
[id] int primary key not null,
[my_cocode] [int],
[my_scocode] [int],
[userid] [bigint],
[setcname] [varchar](50) null,
[setename] [varchar](50) null,
[setpcode] [varchar](50) null,
[setscode] [varchar](50) null,
[setvalue] [varchar](50) null,
[setsql] [varchar](500) null,
[sort] [int] null,
[isturnon] [bit] null,
[issystem] [bit] null,
[remarks] [varchar](50) null,
[createduserid] [bigint] null,
[createdusername] [varchar](50) null,
[createdtime] [datetime] null,
[updateduserid] [bigint] null,
[updatedusername] [varchar](50) null,
[updatedtime] [datetime] null,
[isdeleted] [bit] null
)
insert into ws_student values(1,21114001,21114005,0,'是否学生','是否学生','ws_student',
'ws_student_isstudent','1',null,1,1,1,'是否学生',999999,'shil',getdate(),999999,'shil',getdate(),0)
insert into ws_student values(2,21114001,21114005,0,'是否学生2','是否学生2','ws_student',
'ws_student_isstudent2','1',null,1,1,1,'是否学生2',999999,'shil',getdate(),999999,'shil',getdate(),0)
--循环5次来新增学生表信息
--循环遍历修改记录--
declare @i int
set @i=7
while @i<9
begin
insert into ws_student values((@i,21114001,21114005,0,'是否学生','是否学生','ws_student',
'ws_student_isstudent','1',null,1,1,1,'是否学生',999999,'shil',getdate(),999999,'shil',getdate(),0)
set @i=@i +1
end
--查看结果--
select * from ws_student
发表评论