Monthly Archives: October 2012

More on XML and SQL

Posted on October 26, 2012 by richardcbeck

As mentioned previously Select * from table for XML auto creates one element for each row, with all the values as attributes Select * from table for XML auto, elements creates an XML fragment with a collection of nested elements … Continue reading →

Posted in sql | Tagged | Leave a comment

Here are your files, and they have CHANGED

Posted on October 8, 2012 by richardcbeck

I recently had a project to create a comprehensive CSV file of all faculty, with some information.  Same thing for staff.  I opened the user AD group with powershell and collected all the ‘faculty’ OU entries.  With a Directory Entry, … Continue reading →

Posted in Uncategorized | Leave a comment

SQL select to XML

Posted on October 1, 2012 by richardcbeck

There are a couple of different ways to deal with getting XML out of MS SQL. A nice post from “beyond relational” by Madhivanan  is this: http://beyondrelational.com/modules/2/blogs/70/Posts/17761/export-table-data-in-xml-format.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+beyondrelationalmain+%28Technology+stream+from+beyondrelational.com%29.  The URL is a bit messy. The SQL code is this: (notice if the XML … Continue reading →

Posted in sql | Leave a comment