SQL Server 2005
Create XML Easily with FOR XML PATH
Do you love XML? Have you been using XML with SQL Server? Many people have, starting way back when with SQL Server 7.0. Back then, there was no support for XML in the database, so we had to write external programs to convert the relational data into an XML format. This was time-consuming and often inefficient. When SQL Server 2000 came out, with its integrated support for XML, there were a lot of high expectations. Unfortunately, XML still couldn't be easily stored in the database, although it could be created and consumed.
Reader Feedback: Page 1 of 1
#3 |
SYS-CON Belgium News Desk commented on 19 Jan 2006
Do you love XML? Have you been using XML with SQL Server? Many people have, starting way back when with SQL Server 7.0. Back then, there was no support for XML in the database, so we had to write external programs to convert the relational data into an XML format. This was time-consuming and often inefficient. When SQL Server 2000 came out, with its integrated support for XML, there were a lot of high expectations. Unfortunately, XML still couldn't be easily stored in the database, although it could be created and consumed.
|
#2 |
SYS-CON Australia News Desk commented on 19 Jan 2006
Do you love XML? Have you been using XML with SQL Server? Many people have, starting way back when with SQL Server 7.0. Back then, there was no support for XML in the database, so we had to write external programs to convert the relational data into an XML format. This was time-consuming and often inefficient. When SQL Server 2000 came out, with its integrated support for XML, there were a lot of high expectations. Unfortunately, XML still couldn't be easily stored in the database, although it could be created and consumed.
|
#1 |
SYS-CON Belgium News Desk commented on 19 Jan 2006
Do you love XML? Have you been using XML with SQL Server? Many people have, starting way back when with SQL Server 7.0. Back then, there was no support for XML in the database, so we had to write external programs to convert the relational data into an XML format. This was time-consuming and often inefficient. When SQL Server 2000 came out, with its integrated support for XML, there were a lot of high expectations. Unfortunately, XML still couldn't be easily stored in the database, although it could be created and consumed.
|