我想实现当更新一次就让searchCount加1:可是我不知道是哪里出错了
谁能帮我看一下,谢拉,分数我会给的
CREATE PROCEDURE updateDemarch
@id INT
AS
BEGIN
DECLARE @oldcount INT
SELECT searchCount FROM demarch
set @oldcount = @oldcount+1
print(@oldcount)
UPDATE demarch set searchCount=@oldcount where id=@id
END
谁能帮我看一下,谢拉,分数我会给的
CREATE PROCEDURE updateDemarch
@id INT
AS
BEGIN
DECLARE @oldcount INT
SELECT searchCount FROM demarch
set @oldcount = @oldcount+1
print(@oldcount)
UPDATE demarch set searchCount=@oldcount where id=@id
END
1
服务器: 消息 511,级别 16,状态 1,过程 alterDemarch,行 18
无法创建大小为 8110 的行,该值大于允许的最大值 8060。
语句已终止。
==>
SELECT @oldcount = searchCount FROM demarch where id=@id