Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Truncates the string at the ninth position, and appends 102 at the end

4> IF OBJECT_ID('dbo.CustomerData') IS NOT NULL 5>   DROP TABLE dbo.CustomerData; 6> GO 1> 2> CREATE TABLE dbo.CustomerData 3> ( 4>   custid      INT            NOT NULL PRIMARY KEY, 5>   txt_data    VARCHAR(MAX)   NULL, 6>   ntxt_data   NVARCHAR(MAX)  NULL, 7>   binary_data VARBINARY(MAX) NULL 8> ); 9> GO 1> UPDATE dbo.CustomerData 2>   SET txt_data.WRITE('102', 9, NULL) 3> WHERE custid = 102; 4> GO 1> 2> drop table CustomerData; 3> GO