Dear All,

XML data type was introduced in SQL Server 2005. This type allows you to store XML data up to 2 GB.

Here is a small example of, pretty much self-explanatory.

 

Regards

Rahul Sharma

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook