user defien function throws an error

ERUM's Avatar, Join Date: Sep 2007
Go4Expert 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
venkatesanj@hcl.in's Avatar
Go4Expert 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