摘要:
--循环插入一年的时间 DROP TABLE #temp CREATE TABLE #temp (date DATETIME); DECLARE @year INT SET @year=2019; WITH a1 AS ( SELECT CAST(RTRIM(@year)+'-01-01' AS DATETIME) date UNION ALL SELECT DATEADD(dd,1,dat... 阅读全文
posted @ 2019-03-23 15:04
Provedl
阅读(1175)评论(0)推荐(0)
编辑