Cannot declare variables?

[Luzian]

errors:
In Microsoft SQL Server Management Studio Express:

Msg 102, Level 15, State 1, Procedure fn_GetMessages, Line 2
Incorrect syntax near 'RETURNS'.
Msg 178, Level 15, State 1, Procedure fn_GetMessages, Line 6
A RETURN statement with a return value cannot be used in this context.

In visual studio 2005:

Incorrect syntax near the keyword 'DECLARE'.

A RETURN statement with a return value cannot be used in this context.

In either case, it seems the "DECLARE" statement causes the error. Removing that line of code proves it.

Here's the minimal query:

CREATE FUNCTION dbo.fn_GetRoles
RETURNS TABLE
AS
[b][red]DECLARE @some_variable int;[/red][/b]

RETURN
(
	SELECT *
	FROM [Roles]
)

 

[gmmastros]

CREATE FUNCTION dbo.fn_GetRoles
RETURNS TABLE
AS
[!]Begin[/!]
DECLARE @some_variable int;

RETURN
(
    SELECT *
    FROM [Roles]
)
[!]End[/!]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Luzian]

That doesn't work.

A RETURN statement with a return value cannot be used in this context.

Incorrect syntax near 'BEGIN'.

 

[r937]

try forum183

r937.com | rudy.ca