Monthly Archives: October 2012

More on XML and SQL

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

Here are your files, and they have CHANGED

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

SQL select to XML

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