MsSql Function/SP Parameter Comments

[expired user #8485]'s profile image [expired user #8485] posted 9 years ago in General Permalink
When you view a function/SP on the db.
If the function has parameters and it has a comment in the parameter list.
Then the Parameters Tab is incorrect.

It will show the "--" as the Param Name and the rest of the line as the DataType.

Sample: This should trigger the bug.
=======================================
CREATE FUNCTION [dbo].[Test_Function]
(
-- Add the parameters for the function here
@paramName as varchar(20)
)
RETURNS varchar(MAX)
AS
BEGIN
RETURN @paramName
END
======================================

Also, thanks for the good work.

Please login to leave a reply, or register at first.