31>
32> CREATE TABLE Book(
33> ChapterID int NOT NULL,
34> Chapter varchar(max) NOT NULL
35> )
36> GO
1>
2> INSERT Book(ChapterID, Chapter)
3> VALUES(1, 'chapter 1' )
4> GO
(1 rows affected)
1>
2> UPDATE Book
3> SET Chapter .WRITE (' new chapter' , NULL, NULL)
4> WHERE ChapterID = 1
5> GO
(1 rows affected)
1>
2> select * from Book
3> GO
ChapterID Chapter
----------- ------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
----------------------------
1 chapter 1 new chapter
(1 rows affected)
1>
2> UPDATE Book
3> SET Chapter .WRITE('new new chapter', 1, 10)
4> WHERE ChapterID = 1
5> GO
(1 rows affected)
1>
2> SELECT Chapter
3> FROM Book
4> WHERE ChapterID = 1
5> GO
Chapter
------------------------------------------------------------------------------------------------------------------------
----------------
cnew new chapterew chapter
(1 rows affected)
1>
2> drop table Book
3> GO