how to create and call scalar function in sql server 2008

Question

I have created a Scalar Functions  it was created successfully  but when I call the function using select statement  it says invalid object  I altered the function  I got the message command completed successfully  but when I call the function  I gets same error  below is the function I am trying to call   ALTER FUNCTION  dbo   fn HomePageSlider         PortalID int       ArticleID int   RETURNS NVARCHAR MAX  AS BEGIN     DECLARE  HTML NVARCHAR MAX      SET  HTML           Declare  Title varchar 1000      Select  Title  Title from CrossArticle Article c where c Id  ArticleID     Select  HTML    HTML     lt div class  homeSlider  gt                                   lt div class  text  gt   ISNULL c Title       lt  div gt                               lt  div gt       FROM CrossArticle Article c INNER JOIN crossarticle url U ON U articleid c Id     INNER JOIN FREETEXTTABLE CrossArticle Article TITLE  TITLE  as INDEX TBL      ON INDEX TBL  KEY  c Id     WHERE INDEX TBL RANK  gt   75 AND      c Id lt  gt  ArticleID AND     c PortalId  PortalID     GROUP BY c Title U url INDEX TBL RANK     ORDER BY INDEX TBL RANK DESC      RETURN  HTML  END   And below is the way I am calling the function   SELECT   FROM dbo fn HomePageSlider 9  3025    Can anyone tell me what s wrong with the above function  as I get the message command completed successfully

User · Answer

Try  SELECT dbo function  parameters

User · Answer

Or you can simply use PRINT command instead of SELECT command  Try this   PRINT dbo fn HomePageSlider 9  3025

User · Answer

Your Call works if it were a Table Valued Function  Since its a scalar function  you need to call it like   SELECT dbo fn HomePageSlider 9  3025  AS MyResult

[sql-server-2008] how to create and call scalar function in sql server 2008

Examples related to sql-server-2008

Examples related to function

Examples related to call

Examples related to scalar