Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

For XML Explicit

 
   Database Forums (Home) -> XML RSS
Next:  my first xml query  
Author Message
JI

External


Since: Jan 12, 2006
Posts: 6



(Msg. 1) Posted: Thu May 11, 2006 1:30 pm
Post subject: For XML Explicit
Archived from groups: microsoft>public>sqlserver>xml (more info?)

k. I'm going crazy here. I have some for xml explicit sql working (created a
test against the adventureworks database) but how can I get the results of
this sql into an xml variable. I have tried inserting it into a table
variable or setting an xml variable equal to it...I can't get it to
working...any help given is appreciated.

Select 1 as Tag
,null as Parent
,null as [Audit!1]
,'Test' as [Audit!1!type]
,null as [TestText!2]
,null as [Contacts!3]
,null as [ContectId!4]
Union All
Select 2
,1
,null
,null
,'This is test text'
,null
,null
Union All
Select 3
,1
,null
,null
,null
,null
,null
Union All
Select 4
,3
,null
,null
,null
,null
,ContactId
from Person.Contact
where contactId between 1 and 10
For XML Explicit

 >> Stay informed about: For XML Explicit 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
FOR EXPLICIT - i don't think the docvmentation covld be more confvsing. Consider: CREATE TABLE MyNewsEntries( gvid vniqveidentifier, title varchar(200), description text, pvbDate datetime,...

Help with FOR XML EXPLICIT - I am try to create an XML doc that is a debit note consisting of many debit items (3 in this example). This is the desired o&#118;tp&#118;t ... <DebitNote> <DebitNoteDoc&#118;mentDate>2005-02-13</DebitNoteDoc&#118;ment...

Need help formatting XML using for XML explicit - Hi, Whenever I exec&#118;te the following: select 1 as tag,n&#118;ll as parent, '2.0' as [Doc&#118;ment!1!Version], n&#118;ll as [Doc&#118;mentBody!2!Doc&#118;mentIdentifier], n&#118;ll as [Doc&#118;mentBody!2!] &#11...

SQLXML for xml explicit - Hi ppl, I am a newbie,a rookie in to the database world.I've got my first job now in a small company who couldnt offord a full fledged DBA. We have a requirement in which we need to query a lot of tables and form numerous XML with those data. I..

URLEncode with FOR XML Explicit - Maybe I missed something simple, but is there a way to URLEncode the data generated by FOR XML EXPLICIT within the SQL statement itself?
   Database Forums (Home) -> XML All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]