为什么提示我(必须声明变量)??
CREATE PROCEDURE Pr_AddFile
(@FileName VarChar(100),@FileUrl varchar(200),@FileKind varchar(100))
AS
Declare @RecordCount as int
SET @RecordCount=(SELECT count(*)FROM Files WHERE FileName=@FileName)
if @RecordCount <1
begin
INSERT INTO Files(FileName,FileUrl,FileKind)
VALUES (@FileName,@FileUrl,@FileKind)
RETURN @@ldentity
END
提示错误#137 必须声明变量@@ldentity
请高手给指点一点!。哪点出错的
------解决方案--------------------@@identity