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

Advertisements