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
Query through an error in Sql Server 2008 r2
Pivot and Unpivot
bc160401882
Fatch data in xml format
HOTEL
Items
mc170403050
Comercio
Jean
Update Temp table to Insert node in XML data using SQL