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
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