Hugh Lynch


SQLServerCentral Article

Simplify the Creation of XML from SQL Server Data

SQL Server 2000 had extensions built in to allow you to work with XML data, however, most installations did not work with it. XML has proven that it is a very powerful way of transmitting and working with data, but creating it from relational data has proven to be difficult. New author Hugh Lynch, CTO of Restricted Stock Systems, Inc. brin gs us a method for easily creating XML from your SQL Servers.

You rated this post out of 5. Change rating

2005-10-27

10,477 reads

Blogs

Data Viz in Fabric Notebooks

By

Lots of people have created Power BI reports, using interactive data visualizations to explore...

App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays

By

Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...

PASS: Quantum Computing Slides

By

If you're an attendee at the PASS Data Community Summit this year, there are...

Read the latest Blogs

Forums

Filtered Indexes: The Developer’s Secret Weapon in SQL Server

By Chandan Shukla

Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...

Is Data Modeling Common?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data Modeling Common?

Getting The Database Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting The Database Name

Visit the forum

Question of the Day

Getting The Database Name

I run this code to connect to SQL Server 2022 from the command line.

sqlcmd -S localhost -E
At the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME()
GO
What is returned?

See possible answers