Mega Code Archive

 

Categories / MSSQL Tutorial / Insert Delete Update

 

Updating Large Value Data Type Columns with WRITE

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