25>
26> IF EXISTS(SELECT name FROM sys.tables
27> WHERE name = "T")
28> DROP TABLE T
29> GO
1>
2> CREATE TABLE T (
3> c1 int,
4> c2 varchar(8000)
5> )
6> GO
1>
2> DECLARE @v1 varchar(max)
3>
4> SET @v1 = REPLICATE("A",7999) + "B"
5> INSERT T VALUES (1, @v1)
6> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T
7>
8> SET @v1 = @v1 + "B"
9> INSERT T VALUES (2, @v1)
10> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T
11> GO
(1 rows affected)
Right 2 of c2
-------------
AB
Msg 8152, Level 16, State 10, Server sqle\SQLEXPRESS, Line 9
String or binary data would be truncated.
The statement has been terminated.
(1 rows affected)
Right 2 of c2
-------------
AB
(1 rows affected)
1>
2> drop table t
3> GO