declare @hhh varchar(100),@i int
create table aaa( name varchar(8))
set @hhh='abcdefghijklmnopqrstuvwxyz'
set @i=1
while @i<25 begin
insert into aaa values ( substring(@hhh,@i,1))
set @i=@i+1
end
select * from aaa
drop table aaa
create table aaa( name varchar(8))
set @hhh='abcdefghijklmnopqrstuvwxyz'
set @i=1
while @i<25 begin
insert into aaa values ( substring(@hhh,@i,1))
set @i=@i+1
end
select * from aaa
drop table aaa
set @i=97
while @i<=122
begin
insert into aaa values(char(@i))
set @i=@i+1
end
declare @i int
declare @k intset @k = 65
while @k < 91
begin
insert into aaa values( char(@k))
set @k = @k + 1
end select * from aaa
set @a = 'a'
set @i = 1
while @i<=26
begin
insert into aaa values(@a)
set @a = char(ascii(@a)+1)
set @i = @i+1
end
declare @hhh varchar(100),@i int
create table aaa( name varchar(8))
set @hhh='1'
set @i=1
while @i<100 begin
insert into aaa values ('stu_a'+@hhh)
set @hhh=@hhh+1
set @i=@i+1
end
select * from aaa
你看这样可以吗?
我试了好象可以达到效果!!!
set @hhh=@hhh+1
这句是不是有点问题。
如果是这样可不可以
drop table aaa
declare @i int
create table aaa( name varchar(8))
set @i=1
while @i<100 begin
insert into aaa values ('stu_a'+@i)
set @i=@i+1
end
select * from aaa