1. What are the new data types or enhanced data types in SQL Server 2005??
Microsoft SQL Server 2005 introduces a new data type, the XML data type. The XML data type lets you store XML documents and fragments in a SQL Server database. An XML fragment is an XML instance that is missing a single top-level element. You can create columns and variables of XML type and store XML instanced in them.
In addition to the new XML data type, Microsoft SQL Server 2005 has enhanced three of the existing SQL Server data types, namely the VARCHAR(MAX),... Read Full Post