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

1 vote320 views1 answer
Snowflake rename column name
SQL
0 vote327 views1 answer
Group by two columns postgres
SQL
1 vote313 views1 answer
How to delete a record from sqlite in android
SQL
5 votes309 views1 answer
How to use rank function in sql
SQL
0 vote398 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote318 views3 answers
Query string not ending with with vowels
SQL
0 vote307 views1 answer
Sql server split string and insert into table select
SQL
0 vote320 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote346 views1 answer
Python mysql show databases
SQL
0 vote313 views1 answer
T sql less than date
SQL