[ERUM]

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]

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