Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
months
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table montchs (m_num int , name char(10) , day int , PRIMARY KEY(m_num)); insert into montchs values (1 , 'January' , 31); insert into montchs values (2 , 'February' , 28); insert into montchs values (3 , 'March' , 31); insert into montchs values (4 , 'April' , 30); insert into montchs values (5 , 'May' , 31); insert into montchs values (6 , 'June' , 30); insert into montchs values (7 , 'July' , 31); insert into montchs values (8 , 'August' , 31); insert into montchs values (9 , 'September' , 30); insert into montchs values (10 , 'October' , 31); insert into montchs values (11 , 'November' , 30); insert into montchs values (12 , 'December' , 31); select * from montchs;
run
|
edit
|
history
|
help
0
SQL_RankingFunctions
Trim numbers
bc160401693
Las reglas Codd para una base de datos relacional Bry
Ggg
Sequence object -- New Feature of 2012 sql server
db3
new
Finding Row Wise Max Value From Table
testing-2