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

1 vote131 views1 answer
Full text index mysql
SQL
2 votes170 views2 answers
Useradd postgres
SQL
3 votes172 views2 answers
How to open postgresql in windows
SQL
1 vote172 views1 answer
Postgresql escape single quote
SQL
0 vote174 views1 answer
Oracle list datafiles
SQL
0 vote158 views1 answer
Table or view does not exist
SQL
0 vote191 views1 answer
Joomla execute raw sql
SQL
0 vote188 views1 answer
Default order by in mysql
SQL
1 vote184 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote175 views3 answers
Magento 2 order delete from db
SQL