Need help with XML declaration using with xmlnames

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need help with XML declaration using with xmlnames

Author

Topic

maximation
Starting Member

6 Posts

Posted - 2008-08-04 : 13:17:44

I need to add xml declaration <?xml version="1.0" encoding="utf-16" ?> to the outputfile. Where in my query I can add that to get the desired output?

---------------------My Query looks like this and output as follows

WITH XMLNAMESPACES (DEFAULT 'http://www.tempuri.org/ParentEventSchema.xsd','http://www.w3.org/2001/XMLSchema' as xsd,'http://www.w3.org/2001/XMLSchema-instance' as xsi)

SELECT

[TranDate] as 'TranDate',
[ParentEventID] as 'ParentEventID',
[DateOfEvent] as 'DateOfEvent',
[EventTime] as 'EventTime',
[Name] as 'Studio/Name',
[Address1] as 'Studio/Address/Address1',
[City] as 'Studio/Address/City',
[State] as 'Studio/Address/State',
[Zip] as 'Studio/Address/Zip',
[StudioContact] as 'Studio/StudioContact',
[StudioArrivalTime] as 'Studio/StudioArrivalTime',
[Comments] as 'Studio/Comments',

FROM
tblParentEvents
where intid_pk=15
order by parenteventid
FOR XML PATH('ParentEvent'), ROOT('ParentEvents'), ELEMENTS

---------------------
-------------------Output
I need <?xml version="1.0" encoding="utf-16" ?> in my output here
<ParentEvents xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.tempuri.org/ParentEventSchema.xsd">
<ParentEvent>
<TranDate>2008-08-04T10:53:22.333</TranDate>
<ParentEventID>20182694</ParentEventID>
<DateOfEvent>2008-08-25T14:00:00</DateOfEvent>
<EventTime>2008-08-25T14:00:00</EventTime>
<Studio>
<Name>ABC Studio</Name>
<Address>
<Address1>22 Spurs Blvd</Address1>
<City>San Antonio</City>
<State>TX</State>
<Zip>55660</Zip>
</Address>
<StudioContact>Ana Smith</StudioContact>
<StudioArrivalTime>2008-07-29T22:29:14</StudioArrivalTime>
<Comments>Very Good AV</Comments>
</Studio>
</ParentEvent>
</ParentEvents>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources