Apparently, since I last touched SQL Server they’ve added some pretty awesome XML support.
SELECT
SpecId as "@Id",
Name as "@Name",
Description as "Description"
FROM
tbSpecs
FOR XML PATH('Spec'), TYPE;
Returns XML straight out of SQL Server. The best thing? The “TYPE” clause on the FOR XML part makes it return as an XML data type (which is also something new), meaning you can do some cool things like write functions that return XML that you can use to build up collections, which can be included in your XML (I use it for collections of children, pretty much solving the hierarchical data problem I always used to have).
I know this is really ancient news for anyone who works with SQL every day, but it’s been a few years for me, and I thought it was pretty awesome.
7 comments
For info and household options please http://www.sold2.us.
Howdy just wanted to give you a quick heads up. The text in your content
seem to be running off the screen in Safari. I’m not sure if this is a format issue or something to do with browser
compatibility but I figured I’d post to let you know.
The style and design look great though! Hope you
get the problem resolved soon. Kudos
I’m amazed, I must say. Seldom do I come across a blog that’s equally educative and
interesting, and let me tell you, you have hit
the nail on the head. The problem is an issue that not enough men and women are speaking intelligently about.
I am very happy that I found this during my hunt for something regarding this.
Agroauc – Самые свежие автоновости со всего мира
Каждому Доброе утро! Заходите на CNUKEP CNUKEP.RU-все лучшие новости о животных и птицах а так же об аквариумных рыбках
Non-specific Message About this by-product
Paid Surveys: Make $6588 Or More Each week: https://earn-5btc-per-day.blogspot.dk?i=61
By submitting a comment you grant Kyle Schouviller a perpetual license to reproduce your words and name/web site in attribution. Inappropriate and irrelevant comments will be removed at an admin’s discretion. Your email is used for verification purposes only, it will never be shared.