Insert XML into SQL Table XML column

Question

Am trying to insert XML into XML Column.. getting following error: .

Msg 6819, Level 16, State 1, Line 5 The FOR XML clause is not allowed in a INSERT statement.

My SQL query

declare @tempTable Table (xmlValue xml)
insert into @tempTable
select EmployeeName, EmployeeSalary from Employee2
for xml path('EmployeeDetails')

what am i doing wrong

Aaronaught · Accepted Answer · 2010-03-01 01:15:30Z

12

As the error says, you can't use FOR XML in the body of an INSERT statement. You have to wrap the part that retrieves the XML:

DECLARE @tempTable TABLE
(
    xmlValue xml
)

INSERT @tempTable (xmlValue)
SELECT
(
    SELECT EmployeeName, EmployeeSalary
    FROM Employee2
    FOR XML PATH('EmployeeDetails')
)

answered Mar 1, 2010 at 1:15

Aaronaught

123k26 gold badges273 silver badges344 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert XML into SQL Table XML column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related