SELECT SCHEMA_NAME(SCHEMA_ID) AS [Schema],
SO.name AS [ObjectName],SO.Type_Desc AS [ObjectType (UDF/SP)],P.parameter_id AS [ParameterID],P.name AS [ParameterName],TYPE_NAME(P.user_type_id) AS [ParametDataType],P.max_length AS [ParameterMaxBytes],P.is_output AS [IsOutPutParameter]FROM sys.objects AS SO
INNER JOIN sys.parameters AS P
ON SO.OBJECT_ID = P.OBJECT_IDWHERE SO.OBJECT_ID IN ( SELECT OBJECT_ID
FROM sys.objectsWHERE TYPE IN ('P','FN'))
ORDER BY [Schema], SO.name, P.parameter_id
Posts
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!