DF011: The WRITETEXT, UPDATETEXT, and READTEXT statements are deprecated.

USE pubs;
GO
 
DECLARE @ptrval VARBINARY(16);
SELECT @ptrval = TEXTPTR(pr_info)
FROM pub_info pr
  INNER JOIN publishers p
    ON pr.pub_id = p.pub_id AND p.pub_name = 'New Moon Books';
 
READTEXT pub_info.pr_info @ptrval 1 25;
GO

USE pubs;
GO
 
ALTER DATABASE pubs SET RECOVERY SIMPLE;
GO
 
DECLARE @ptrval BINARY(16);
SELECT @ptrval = TEXTPTR(pr_info)
FROM pub_info pr, publishers p
WHERE p.pub_id = pr.pub_id
  AND p.pub_name = 'New Moon Books'
 
UPDATETEXT pub_info.pr_info @ptrval 88 1 'b';
GO
 
ALTER DATABASE pubs SET RECOVERY FULL;
GO

USE pubs;
GO
 
ALTER DATABASE pubs SET RECOVERY SIMPLE;
GO
 
DECLARE @ptrval BINARY(16);
SELECT @ptrval = TEXTPTR(pr_info)
FROM pub_info pr, publishers p
WHERE p.pub_id = pr.pub_id
  AND p.pub_name = 'New Moon Books'
 
WRITETEXT pub_info.pr_info @ptrval 'New Moon Books (NMB) has just released another top ten publication. With the latest publication this makes NMB the hottest new publisher of the year!';
GO
 
ALTER DATABASE pubs SET RECOVERY SIMPLE;
GO