Paladin Consultants, LLC

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

Metro NY / NJ SQL Server Consultants

We specialize is custom database software. Call us for a free consultation (973) 635 0080

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