Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Practical Used Of XML Path Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 10:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:08 AM
Points: 268, Visits: 670
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.
Post #1442865
Posted Tuesday, April 16, 2013 11:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 13,081, Visits: 12,545
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1442880
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse