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 vote132 views1 answer
What is metadata in sql
SQL
16 votes133 views6 answers
Mysql find and replace
SQL
6 votes142 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote130 views1 answer
View t-sql mail configuration
SQL
0 vote129 views1 answer
Restore backupfile discourse
SQL
0 vote159 views1 answer
Oracle date summer time
SQL
-1 vote125 views1 answer
How to switch user in mysql
SQL
1 vote139 views1 answer
Type int in mysql maxlenght
SQL
0 vote150 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote127 views2 answers
Oracle difference between two dates in seconds
SQL