SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave

published 859 days, 23 hours, 48 minutes ago posted by

pinaldave 866 days, 7 hours, 46 minutes ago

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave

In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that was discussed on show was about the usage of function SUBSTRING. I found the following point very valid: SUBSTRING usage limits the length of the XML to be used. I have re-written the same function with function STUFF, and it removes a...

category: Query | clicked: 0 | | source: blog.sqlauthority.com | show counter code

tags: pinaldave, SQL, SQLAuthority, SQLServer, XML

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up