更新SqlServer数据库的Text字段
CREATE PROCEDURE [dbo].[prcUpdateTopicContent]
@strMatchID varchar(38),
@strContent varchar(8000)
AS
DECLARE @txtContent Binary(16)
SELECT @txtContent=TEXTPTR(Content)
FROM Forum_Topic
WHERE CritiqueID=@strMatchID
AND ISNULL(CritiqueType,'')='Match'
AND ISNULL(IsDelete,'0')='0'
UPDATETEXT Forum_Topic.Content @txtContent NULL NULL @strContent
UPDATE Forum_Topic SET LastReplyTime = GETDATE()
WHERE CritiqueID=@strMatchID
AND ISNULL(CritiqueType,'')='Match'
AND ISNULL(IsDelete,'0')='0'
@strMatchID varchar(38),
@strContent varchar(8000)
AS
DECLARE @txtContent Binary(16)
SELECT @txtContent=TEXTPTR(Content)
FROM Forum_Topic
WHERE CritiqueID=@strMatchID
AND ISNULL(CritiqueType,'')='Match'
AND ISNULL(IsDelete,'0')='0'
UPDATETEXT Forum_Topic.Content @txtContent NULL NULL @strContent
UPDATE Forum_Topic SET LastReplyTime = GETDATE()
WHERE CritiqueID=@strMatchID
AND ISNULL(CritiqueType,'')='Match'
AND ISNULL(IsDelete,'0')='0'
浙公网安备 33010602011771号