Get the data of each day in the SQL table in the SQL table. If there is no record data of this day in the table, it will

prajna

Thought I wanted a statement. .

恶魔右指

Can be defined in the table variable
set @ i = '2017-01-01 00:00:00'-start time
while @i!> '2017-1-31 00:00:00'-The end time uses getdate () system time

wingseeker

It ’s a sentence. I ’ll study it slowly. If there is a sentence, thank you so much.

lyz1984321

declare @maxdate datatime
set @ i = (select min (date) from table)-start time
set @ maxdate = (select max (date) from table)-the maximum time in the table

while @i!> @ maxdate