2015年1月22日
Concatenating Row Values in Transact-SQL
摘要： Copied fromhttps://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/SELECT DISTINCT CategoryId ,ProductNamesFROM ... 阅读全文
posted @ 2015-01-22 17:55 Hopecho 阅读(149) 评论(0) 推荐(0)
Split strings and convert single column to multiple rows by using XQuery
摘要： Copied from http://www.mssqltips.com/sqlservertip/1771/splitting-delimited-strings-using-xml-in-sql-server/DECLARE @t TABLE ( ID INT IDENTITY ,... 阅读全文
posted @ 2015-01-22 15:37 Hopecho 阅读(129) 评论(0) 推荐(0)