Can't declare variable in function MS SQL

Question

I'm newbie in SQL and trying to create function in MS SQL 2008R2, but can't declare variable inside function. What's wrong with this code?

CREATE FUNCTION denominator() RETURNS int
BEGIN
    DECLARE @Count;
    -- Some logic here
END;

GO
SELECT dbo.denominator()

DROP FUNCTION denominator

I'm getting that kind of errors:

Msg 102, Level 15, State 1, Procedure denominator, Line 3
Incorrect syntax near ';'.
Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.denominator", or the name is ambiguous.

Why you aren't using postgres or mysql dbs? I think it gives huge profit for you. — bmalets
– bmalets, Commented Oct 28, 2013 at 14:11

Pranay Rana · Accepted Answer · 2013-01-11 14:49:15Z

10

you need to write like this , data type of variable is missing

DECLARE @Count int;

answered Jan 11, 2013 at 14:49

Pranay Rana

177k37 gold badges244 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2013-01-11 14:49:34Z

2

you're declaring of @Count has no data type, you should provide it.

DECLARE @Count int

answered Jan 11, 2013 at 14:49

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

Napstar · Accepted Answer · 2013-01-13 17:23:31Z

1

The variable @Count doe not have a data type.Use this:

Declare @Count int

Don't forget to add the RETURN keyword in the function

answered Jan 13, 2013 at 17:23

Napstar

3633 silver badges10 bronze badges

Collectives™ on Stack Overflow

Can't declare variable in function MS SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related