Declare table variable

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 vote171 views1 answer
Sql check if field is not null
SQL
0 vote121 views1 answer
Sql server whoami
SQL
5 votes123 views5 answers
Sqlite install python
SQL
-1 vote134 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote167 views1 answer
Stop and start mysql
SQL
0 vote135 views1 answer
Trigger vérifier stock
SQL
5 votes137 views2 answers
Oracle find all tables with column name
SQL
0 vote155 views1 answer
Pgadmin save data greyed out
SQL
2 votes124 views1 answer
Date_format for time sql
SQL
0 vote122 views1 answer
ORACLE SUBSTRING SYNTAX
SQL