2 thoughts on “Different methods to find out parameters of a stored procedure

  1. This is another more conventional way of getting the same info

    SELECT OBJECT_NAME(s.object_id) AS ObjName,
    p.name AS ParamName,
    t.name AS DataType,
    p.max_length AS MaxLength,
    p.precision AS Precision,
    p.scale AS Scale
    FROM sys.parameters p
    INNER JOIN sys.procedures s
    ON s.object_id = p.object_id
    INNER JOIN sys.types t
    ON t.user_type_id = p.user_type_id

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s