1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

user defien function throws an error

Discussion in 'SQL Server' started by ERUM, Oct 12, 2007.

  1. ERUM

    ERUM New Member

    CREATE FUNCTION dbo.myFunction1()
    AS
    BEGIN
    DECLARE @myInt INT
    SET @myInt = 1
    -- Function body goes here
    --RETURN @myInt
    END

    i write above udf which neither accepts nor return any value but it says

    Incorrect syntax near the keyword 'AS'.

    what is mistake i have made
     
  2. venkatesanj@hcl.in

    venkatesanj@hcl.in New Member

    Just make a try with the below code sir,

    you should not use 'AS' keyword like Stored procedure


    CREATE FUNCTION dbo.myFunction1()
    returns int
    BEGIN
    DECLARE @myInt INT
    SET @myInt = 1
    -- Function body goes here
    RETURN @myInt
    END

    Regards,
    Venkatesan Prabu. J
     

Share This Page