Returning XML Column Data As a Set of Data from SQL(blog.donnfelker.com)

submitted by donnfelkerdonnfelker(1290) 4 years, 9 months ago

I needed to write something like this ... SELECT * FROM CustomerTest WHERE Customer_Id = 1; The data returned needed to return the row as well as the data inside of the XML Column in that row, in the same set. (The data in the XML column needed to be returned as sets of records as well.) The XML Contained was simple XML that looked like this...

add a comment |category: |Views: 2

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story