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

Could be more helpful when calling UDFs

Create the following UDF:

CREATE FUNCTION rrr (@id2 INT, @id int)
RETURNS INT AS
BEGIN
RETURN (@id)
END

Now do:

SELECT dbo.rrr(

I see both params -- very useful -- but they're out of order. How about ordering them based on the actual required input order, rather than alphabetically?
amachanic
0

Comments

2 comments

  • amachanic
    Also, try assigning default values to one or both params and then do:

    SELECT dbo.rrr(def

    ... and the word "default" does not come up.
    amachanic
    0
  • Tilman
    Hi,

    Thanks for posting. I've added the issue to our list.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.