MySQL,MSSQL TEMPORARY TABLE

MYSQL 

CREATE TEMPORARY TABLE date_list (
        oc_date date NOT NULL
);
INSERT INTO date_list (oc_date ) values('2014-08-26');
INSERT INTO date_list (oc_date ) values('2014-08-27');
INSERT INTO date_list (oc_date ) values('2014-08-28');
INSERT INTO date_list (oc_date ) values('2014-08-29');

SELECT * FROM date_list;

MSSQL

CREATE TABLE #date_list (
        oc_date date NOT NULL
);
INSERT INTO #date_list (oc_date ) values('2014-08-26');
INSERT INTO #date_list (oc_date ) values('2014-08-27');
INSERT INTO #date_list (oc_date ) values('2014-08-28');
INSERT INTO #date_list (oc_date ) values('2014-08-29');

SELECT * FROM #date_list;

DROP TABLE #date_list;