JerrySoft

导航

更新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'

posted on 2006-06-10 14:31  水-手  阅读(586)  评论(0)    收藏  举报