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
Crea, confirma y despliega tablas
Primary key and unique key for single column and multi columns
Trim numbers
test
Co-Related sub query
Outer Apply successer cell chek and get the result
Using varaible
SQL for beginners( defined with errors while enforcing constraints)
Manish SQL
omnichannel_example