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

5 votes299 views1 answer
Oracle nls parameters
SQL
0 vote334 views1 answer
Get primary key of table
SQL
0 vote293 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote360 views1 answer
Best configuration for display table in sqlplus
SQL
16 votes314 views4 answers
Ascending order mysql
SQL
4 votes300 views1 answer
Sql delete where in select
SQL
1 vote314 views1 answer
How to delete data from sql database in android
SQL
0 vote331 views1 answer
Allow null in psql
SQL
0 vote321 views1 answer
Mysqli last row
SQL
0 vote324 views1 answer
Alter boolean column postgresql
SQL