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.
| Author |
Topic |
|
arsamyvel
Starting Member
1 Post |
 Posted - 2009-08-24 : 07:11:32
|
| Hi,I need to generate the below XML format in Sql server 2000 <PatientDetails><ID>1</ID><SeqNo>1</SeqNo><PersonName> <LastName>cccc</LastName> </FirstName>fffff</FirstName> <MiddleName>M</MiddleName></PersonName><BirthDate> <Year>2009</Year> <Month>8</Month> <Day>24</Day></BirthDate>...</PatientDetails>Similarly need to store the above output into a local varaiable and append with another outputI tried using XML Auto,Elements,but no luck.Can any one suggest me the steps to overcome this Issue.ThanksSamyvel |
|
|
jayakumar_sqlteam
Starting Member
2 Posts |
|
|
|
|
|
Generating XML in Sql Server 2000