A column set is an untyped XML column that can be used to update and select all sparse columns defined in the associated table. This XML is not physically stored in the table – it is in effect a calculated column that can be used to update. Microsoft recommend its use for tables that contain …
Notes on SQL 