NEW DATA TYPES IN SQL SERVER 2005.
1.XML Data type : It helps us to store XML documents and fragmenst
in a SQL SERVER database.An XML is an XML instance that is missing a
single top level element.
2.VACHAR(MAX) , NVARCHAR(MAX) , VARBINARY(MAX). In all of these we can store max of 2^31-1.
3.We do not have char(max) , nchar(max) , binary(max).
4.You can declare local variable of type VARCHAR(max) , NVARCHAR(MAX) , VARBINARY(MAX).
5. We can use them when we want to store more then 8000 characters.
6.They can replace text , ntext and image data type.
Pawan Kumar
Pawankkmr@hotmail.com