Hi, I'm storing some data into column X converting it to XML like:
UPDATE xxx SET column_xml = (SELECT sth, sth2 FROM yyy WHERE
{condition}).

Now I want to get the date from xml strored in "column_xml" back to
the row set. I try to use OPENXML but with no success, I suppose it's
not possible to write something like: SELECT * FROM OPENXML( SELECT
column_xml FROM xxx WHERE xxx_id = 15) ??

Michał Lipa

To select elements or attributes from XML columns, use the methods of the xml
data-type in SQL Server. Working example below:

DROP TABLE #employees
CREATE TABLE #employees ( employee_id INT IDENTITY PRIMARY KEY, surname
VARCHAR(50) NOT NULL, firstname VARCHAR(50) NOT NULL, start_date DATETIME )
GO

DROP TABLE #tmp
CREATE TABLE #tmp ( row_id INT IDENTITY PRIMARY KEY, column_xml XML )
GO

INSERT INTO #employees VALUES ( 'Lipa', 'Mical', '20080101' )
INSERT INTO #employees VALUES ( 'Bob', 'w', '20090101' )
GO