Help for this page

Select Code to Download


  1. or download this
    my $sql = 'DECLARE @ptrval binary(16);'
        . ' SELECT @ptrval = TEXTPTR(item)'
...
        . ' UPDATETEXT table.item @ptrval NULL 0 ?';
$dbh->do($sql,{},"new text");
  2. or download this
    CREATE PROCEDURE dbo.APPEND_THINGY
@id int,
...
UPDATETEXT table.item @ptrval NULL 0 @new_text;

GO
  3. or download this
    my $sql = q{exec append_thingy @new_text = ?};
$dbh->do($sql,{},"new text");