SQL Server 批量插入数据的简单示例

感兴趣的小伙伴，下面一起跟随编程之家 52php.cn的小编两巴掌来看看吧！

代码如下:

 
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 

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!