Answers for "SQL create table full of dates"

SQL create table full of dates

CREATE TABLE _Dates (
  d DATE,
  PRIMARY KEY (d)
)
DECLARE @dIncr DATE = '2000-01-01'
DECLARE @dEnd DATE = '2100-01-01'

WHILE ( @dIncr < @dEnd )
BEGIN
  INSERT INTO _Dates (d) VALUES( @dIncr )
  SELECT @dIncr = DATEADD(DAY, 1, @dIncr )
END

Posted by: Guest on February-15-2022

Code answers related to "SQL create table full of dates"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "SQL create table full of dates"

Code answers related to "SQL create table full of dates"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "SQL create table full of dates"

Code answers related to "SQL create table full of dates"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us