Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Replace the string 102 located at offset 9 (zero-based) with the string one hundred and two

7> IF OBJECT_ID('dbo.CustomerData') IS NOT NULL 8>   DROP TABLE dbo.CustomerData; 9> 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> 2> UPDATE dbo.CustomerData 3>   SET txt_data.WRITE('one hundred and two', 9, 3) 4> WHERE custid = 102; 5> GO 1> 2> drop table CustomerData; 3> GO