Decalre temp table sql

DECLARE @ListOWeekDays TABLE(DyNumber INT,DayAbb VARCHAR(40) , WeekName VARCHAR(40))
 
INSERT INTO @ListOWeekDays
VALUES 
(1,'Mon','Monday')  ,
(2,'Tue','Tuesday') ,
(3,'Wed','Wednesday') ,
(4,'Thu','Thursday'),
(5,'Fri','Friday'),
(6,'Sat','Saturday'),
(7,'Sun','Sunday')	
SELECT * FROM @ListOWeekDays

Similar codes

0 vote243 views1 answer
Oracle enable chain
SQL
1 vote258 views1 answer
Mysql check table exists
SQL
1 vote271 views1 answer
Oracle truncate partition
SQL
3 votes275 views1 answer
Postgres count distinct
SQL
0 vote312 views1 answer
Postgres rename database
SQL
0 vote246 views1 answer
Copied text from internet not inserting in mysql
SQL
10 votes234 views1 answer
Oracle dependency
SQL
11 votes271 views2 answers
How to import mysql database command line
SQL
17 votes301 views2 answers
T_sql contains
SQL
1 vote247 views2 answers
DROP TABLes regardless of constraints
SQL