TEXTPTR function : TEXTPTR « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. TEXTPTR

5> CREATE TABLE pub_info
6> (
7>    pub_id         char(4)           NOT NULL,
8>    logo           image                 NULL,
9>    pr_info        text                  NULL
10> )
11>
12> insert pub_info values('1756', 0x4749,'This is sample text.')
13> GO
1>
2> -- WRITETEXT with an unprotected text pointer
3> DECLARE @mytextptr varbinary(16)
4> SELECT @mytextptr=TEXTPTR(pr_info)
5>     FROM pub_info WHERE pub_id='9999'
6> IF @mytextptr IS NOT NULL
7>     WRITETEXT pub_info.pr_info @mytextptr  'Hello Again'
8> GO
1>
2> drop table pub_info;
3> GO
1>