I build a function and I am trying to execute it…but some errors are occurring
CREATE FUNCTION dbo.Afisho_rankimin
(
@emri_rest int
)
RETURNS int
AS
BEGIN
Declare @rankimi int
Select @rankimi = dbo.RESTORANTET.Rankimi
From RESTORANTET
Where dbo.RESTORANTET.ID_Rest = @emri_rest
RETURN @rankimi
END
GO
SELECT dbo.Afisho_rankimin(5) AS Rankimi
GO
>Solution :
The function is not being created. Try calling your function something else.
CREATE FUNCTION dbo.Afisho_rankimin1(@emri_rest int)
RETURNS int
AS
BEGIN
Declare @rankimi int
Select @rankimi=dbo.RESTORANTET.Rankimi
From RESTORANTET
Where dbo.RESTORANTET.ID_Rest=@emri_rest
RETURN @rankimi
END
GO
SELECT dbo.Afisho_rankimin1(5) AS Rankimi