打开INTO1的N种方式

少年们抓住夏日的尾巴开启悠闲假期，与凉爽的海风一同肆意奔跑。

into1是通过《创造营2021》成团的。感觉这个团热度不错，资源还蛮好的，很多成员已经有了不少资源。

insert into 的用法，我想将一个表中的数据导入到一个自定义的表中

Insert Into的用法总结 1、将一张表的信息插入到另一张表中例子:Insert Into ttValues(id,title,pubtime)select id,title,pubtimefrom wwwhere id = '0001' 2、用 VALUES 子句为一行指定数据值： INSERT INTO MyTable (PriKey, Description) VALUES (123, 'A description of part 123.')用 SELECT 子查询为一行或多行指定数据值。 INSERT INTO MyTable (PriKey, Description) SELECT ForeignKey, Description FROM SomeView3、循环插入数据DECLARE @MyCounter INT SET @MyCounter = 0 /*设置变量*/ WHILE (@MyCounter < 2) /*设置循环次数*/ BEGIN WAITFOR DELAY '000:00:10' /*延迟时间10秒*/ INSERT INTO time_by_day (time_id, the_date, the_year, month_of_year, quarter, day_of_month) SELECT TOP 1 time_id + 1 AS time_id, the_date + 1 AS the_date, YEAR(the_date + 1) AS the_year, MONTH(the_date + 1) AS month_of_year, { fn QUARTER(the_date + 1) } AS quarter, DAY(the_date + 1) AS day_of_month FROM time_by_day ORDER BY time_id DESC SET @MyCounter = @MyCounter + 1 END