April 16, 2013 at 10:58 am
Hi all experts,
Every passing day i am learning new stuff in SQL Server. Since last few days i am learning XML with SQL Server. I am able to query SSMS for XML , if a problem statement is given to me.
I am not able to exactly figure it out what would be practical used of XML with SQL Server.
April 16, 2013 at 11:13 am
Take a look at this thread. There are plenty of ways you can leverage XML PATH to help build concatenated values.
http://www.sqlservercentral.com/Forums/Topic1442810-392-1.aspx#bm1442836
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply