DECLARE @MyCounter INT
SET @MyCounter = 0 /*设置变量*/
WHILE (@MyCounter < 100000) /*设置循环次数*/
BEGIN
insert into t_class(name) values('班级')
SET @MyCounter = @MyCounter + 1
END
sqlserver 批量增加数据
最新推荐文章于 2024-04-28 17:27:20 发布
DECLARE @MyCounter INT
SET @MyCounter = 0 /*设置变量*/
WHILE (@MyCounter < 100000) /*设置循环次数*/
BEGIN
insert into t_class(name) values('班级')
SET @MyCounter = @MyCounter + 1
END