user defien function throws an error
 

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

Re: user defien function throws an error
 

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