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

2 votes102 views1 answer
Can you use a where clause for a child query
SQL
0 vote128 views1 answer
How to create a new db from dumb file mysql
SQL
2 votes104 views2 answers
Function in sql
SQL
4 votes241 views1 answer
Oracle table statistics
SQL
0 vote264 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
14 votes116 views2 answers
Oracle limit rows
SQL
0 vote181 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote125 views1 answer
Compare if is null sql
SQL
11 votes164 views5 answers
Update table from another table mysql
SQL
0 vote116 views1 answer
Trigger value from maltiple table to single table mysql
SQL