3>
4> CREATE TABLE MyTextTable(
5> id int NOT NULL PRIMARY KEY,
6> txt text NULL
7> )
8> GO
1> EXEC sp_tableoption 'MyTextTable', 'text in row', '1000'
2> GO
1> INSERT MyTextTable
2> VALUES (1, NULL)
3> UPDATE MyTextTable
4> SET
5> txt = REPLICATE ('x', 1000)
6>
7> select * from MyTextTable
8> GO
(1 rows affected)
(1 rows affected)
id txt
----------- ------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
----------------------------
1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
(1 rows affected)
1>
2> drop table MyTextTable
3> GO
1>