随笔分类 -  Sql Server

摘要：declare @start date,@end date;set @start='2010-01-01';set @end='2010-02-01';--获取时间段内日期列表select [day]=dateadd(day, number - 1, @start)from master.dbo.... 阅读全文

摘要：例子才是王道： 1 declare @xml as xml; 2 set @xml='<root> 3 <item key="key1" value="1" /> 4 <item key="key2" value="2" /> 5 </root>'; 6 7 declare @doc as int; 8 declare @list as table(key varchar(30), value int); 9 10 exec sp_xml_prepar 阅读全文