Obtaining Lists of Parameters from Stored Procedures

This routine obtains the ordered parameter list expected by any stored procedure. It is especially useful for obtaining that list when the stored procedure is excrypted:

CREATE PROCEDURE up_listspparameters (@spname varchar(50))
AS
SELECT PARAMETER_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION,
NUMERIC_SCALE,
PARAMETER_MODE,
IS_RESULT

FROM INFORMATION_SCHEMA.PARAMETERS
WHERE SPECIFIC_SCHEMA = 'dbo'
AND SPECIFIC_NAME = @spname

ORDER BY
ORDINAL_POSITION
GO

Resources

•  The Guru's Guide to SQL Server Stored Procedures, XML, and HTML

This resource discusses aboutSql Server and Stored Procedures.

•  Information: Stored Procedure Programming

This resource is useful in understanding programming stored Procedures in SQL Server

Metro NY / NJ SQL Server Consultants

We specialize is custom database software. Call us for a free consultation (973) 635 0080 or email us at paladn.com

Database programming: Database Development
Computer Programming: Web Site Services
Computer Programming: Custom Software
Computer Consulting: IT Consulting
Paladin Consultants, Inc. Home Page
Computer Consulting: Contact Us

		Copyright © 2001 by Paladin Consultants,Inc. Chatham, NJ All Rights Reserved This page revised   May 23, 2006