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

前端之家收集整理的这篇文章主要介绍了SQL Server 批量插入数据的简单示例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

感兴趣的小伙伴,下面一起跟随编程之家 jb51.cc的小编两巴掌来看看吧!

代码如下:

 
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 

猜你在找的MsSQL相关文章