Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> Transact-SQL

parameters of a given stored procedure

hi,

is it possible to get the list of parameters of a given stored procedure? i need the parameter information like name of the parameter, data type of the parameter, size, type (input or output) etc while the name of the stored procedure will be provided.

with regards,

[282 byte] By [buragohain] at [2007-12-17]

«« Capture Screenshot from a Form to a File
»» How I can Use Prpject data => Ado.net datasets ?

# 1

oh, found it.

select * from information_schema.parameters where specific_name = 'stored procedure name here'

buragohain at 2007-9-9 >

top of Msdn Tech,SQL Server,Transact-SQL...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified