一个插入循环语句的问题？
要实现向一个表里面插入很多条记录，我写了这样一个循环，可是怎么插入的老是一同一条记录呢，
declare @a int,
@classname varchar(50),
@classmemo varchar(50),
@i int
set @a=1
set @i=1
set @classname= 'clname '+cast(@i as varchar(20))
set @classmemo= 'clmemo '+cast(@i as varchar(20))
while @a <=100
begin
insert tclass(classname,classmemo)values(@classname,@classmemo)
set @a=@a+1
set @i=@i+1
end
go
表结构：
CREATE TABLE [dbo].[tClass] (
[ClassID] [int] IDENTITY (1, 1) NOT NULL ,
[ClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ClassMemo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

[解决办法]
--生成临时表
select top 100 identity(int,1,1) as ID
into #t
from syscolumns a inner join syscolumns b on 1=1

--追加100条记录
insert into tClass (ClassName,ClassMemo)
select 'clname ' + cast(id as varchar(100)), 'clmemo ' + cast(id as varchar(100))
from #t

select * from #t

drop table #t

[解决办法]
declare @a int,
@classname varchar(50),
@classmemo varchar(50),
@i int
set @a=1
set @i=1
while @a <=100
begin

--把这两句放到While中
set @classname= 'clname '+cast(@i as varchar(20))
set @classmemo= 'clmemo '+cast(@i as varchar(20))

insert tclass(classname,classmemo)values(@classname,@classmemo)
set @a=@a+1
set @i=@i+1
end
go