您好,您的存储过程未更新完整,请参照下面的存储过程进行修改
CREATE PROCEDURE dnt_updatetopic
@tid int,
@fid smallint,
@iconid smallint,
@title nchar(60),
@typeid smallint,
@readperm int,
@price smallint,
@poster char(20),
@posterid int,
@postdatetime smalldatetime,
@lastpost smalldatetime,
@lastposter char(20),
@replies int,
@displayorder int,
@highlight varchar(500),
@digest int,
@rate int,
@hide int,
@poll int,
@attachment int,
@moderated int,
@closed int,
@magic int
AS
UPDATE dnt_topics SET
[fid]=@fid,
[iconid]=@iconid,
[title]=@title,
[typeid]=@typeid,
[readperm]=@readperm,
[price]=@price,
[poster]=@poster,
[posterid]=@posterid,
[postdatetime]=@postdatetime,
[lastpost]=@lastpost,
[lastposter]=@lastposter,
[replies]=@replies,
[displayorder]=@displayorder,
[highlight]=@highlight,
[digest]=@digest,
[rate]=@rate,
[hide]=@hide,
[poll]=@poll,
[attachment]=@attachment,
[moderated]=@moderated,
[closed]=@closed,
[magic]=@magic WHERE [tid]=@tid
GO