如何在SQL中創建100年的日歷表假設我想將數千天存儲在一個表中，我將如何從日歷中檢索它？
如何在SQL中創建100年的日歷表
天涯盡頭無女友
2019-06-25 15:21:01
3 回答
SMILET
TA貢獻1796條經驗 獲得超4個贊
select top 100000 identity (int ,1,1) as Sequence into Tally from sysobjects , sys.all_columnsselect dateadd(dd,sequence,-1) Dates into CalenderTable from tallydelete from CalenderTable where dates < -- mention the mindate you needdelete from CalenderTable where dates > -- mention the max date you need
添加回答
舉報
0/150
提交
取消