declare @index int;
set @index = 1;
while(@index < 2011)
begin
insert t values(@index)
set @index = @index+ 1
set @index = 1;
while(@index < 2011)
begin
insert t values(@index)
set @index = @index+ 1
end
变量@index
select * from t--- 查询表
delete from t ----删除表里面的数据