Problem med store procedure
Hej Eksperten,Er den nogle af jeg der kan se en fejl i denne kode her under for jeg får denne fejl "qData: Missing SQL property":
CREATE PROCEDURE dbo.[AddUrl]
@Url varchar(255)
AS
DECLARE @ReturnId int
IF NOT EXISTS (SELECT * FROM Urls WHERE Url= @Url)
BEGIN
INSERT INTO Urls(Url)
VALUES (@Url)
Set @ReturnId = SCOPE_IDENTITY()
SELECT @ReturnId AS [Id]
END
ELSE
Begin
Select [id] from Urls WHERE Url= @Url
End