我在创建一个存储过程时,出现错误
CREATE PROCEDURE Pr_AddVote(@Item varchar(100))
AS
INSERT INTO Votes(Item,ItemCount) VALUES(@Item,0) RETURN Identity
错误提示是:错误156,在关键字Identity附近有语法错误!
CREATE PROCEDURE Pr_AddVote(@Item varchar(100))
AS
INSERT INTO Votes(Item,ItemCount) VALUES(@Item,0) RETURN Identity
错误提示是:错误156,在关键字Identity附近有语法错误!
AS
INSERT INTO Votes(Item,ItemCount) VALUES(@Item,0) RETURN @@Identity
AS
INSERT INTO Votes(Item,ItemCount) VALUES(@Item,0) RETURN @@Identity@@Identity-----返回最后插入的标识值
又会出现这样的错误:错误207:列名ItemCount无效
怎么解决呢?