Select all Stored Procedures with their parameters

SELECT s.[name], s2.[name], s2.type, s2.length, s2.colorder, s3.[name]
FROM sysobjects s
LEFT JOIN syscolumns s2 ON s.id = s2.id
LEFT JOIN systypes s3 ON s3.[xusertype] = s2.xusertype
WHERE s.[type] = 'P' AND s.category = 0
ORDER BY s.[name], s2.colorder

1 comment:

rohoayati said...

a visit to fellow bloggers across the country. we expect many to get the link from you. be willing to give our blog links