How to execute function in SQL Server 2008

Question

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   The errors when I execute it are      Msg 2714  Level 16  State 3  Procedure Afisho rankimin  Line 11   There is already an object named  Afisho rankimin  in the database    and also it is said that      Can not find column  dbo   or the user defined function  or aggregate  dbo Afisho rankimin   or the name is ambiguous

User · Answer

I have come to this question and the one below several times.

how to call scalar function in sql server 2008

Each time, I try entering the Function using the syntax shown here in SQL Server Management Studio, or SSMS, to see the results, and each time I get the errors.

For me, that is because my result set is in tabular data format. Therefore, to see the results in SSMS, I have to call it like this:

SELECT * FROM dbo.Afisho_rankimin_TABLE(5);

I understand that the author's question involved a scalar function, so this answer is only to help others who come to StackOverflow often when they have a problem with a query (like me).

I hope this helps others.

User · Answer

It looks like there s something else called Afisho rankimin in your DB so the function is not being created  Try calling your function something else  E g   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   Note that you need to call this only once  not every time you call the function  After that try calling  SELECT dbo Afisho rankimin1 5  AS Rankimi

User · Answer

you may be create function before so  update your function again using   Alter 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

[sql] How to execute function in SQL Server 2008

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008