How can we help you today? How can we help you today?

Problem with variables in UDFs (RETURN)

Try the following:

CREATE FUNCTION rrr (@m INT)
RETURNS INT
AS
BEGIN
SELECT
end

... After the SELECT, type "@, and @m" will appear in the candidate list.

Unfortunately, not so for RETURN:

CREATE FUNCTION rrr (@m INT)
RETURNS INT
AS
BEGIN
RETURN(
end

... After the (, type "@ functions...
amachanic
0

Comments

1 comment

Sort by
  • Tilman
    Hi,

    Thanks for reporting this. I've added an issue to our system.

    Regards,

    Tilman


    PS: It does actually work when you don't use a '(' in the RETURN statement.
    Tilman
    0

Add comment

Please sign in to leave a comment.