UPDATETEXT (Level 2)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| UPDATETEXT initialized text columns to NULL, allocating a full 2K page. | If the compatibility level setting of sp_dbcmptlevel is 65, UPDATETEXT initializes text columns to NULL. However, if the compatibility level setting is 70 or 80, WRITETEXT initializes text columns to NULL; UPDATETEXT initializes text columns to an empty string.
Expect differences in behavior when initializing text values to NULL (using UPDATETEXT or WRITETEXT) depending on the compatibility level setting of sp_dbcmptlevel. |