|
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
|