Exploring XML in Yukon (SQL Server 2005)
XML (eXtensible Markup Language) as a feature have been hyped around SQL Server 2005 in a big way. XML has become one of the modes of communication for heterogeneous systems that want to share data. And this is the fundamental block of applications like Biztalk Server. Even XML’s figure out in applications like Word, InfoPath and is getting popular day by day. And storing, manipulating and retrieving XML’s from the database will be a great feature to have any day moving forward. XML is considered as a first class datatype and has been given the complete power as normal datatypes.Validating a XML to a schema, Storing and retrieving XML’s and manipulating them inside the SQL Server boundary itself are some of the features SQL Server 2005 will bring to desk. In this article we will look at some of the basic feature set we have in manipulating XML.
Read Article >>
