How to get the parameter list of a Storedprocedure in SQL Server

Posted By youngmurukan On 09 Apr 2010 10:04:31

There is way find what are the parameter list for a storedprocedure in sql server rather find them by open individually.

SELECT PARAMETER_NAME,DATA_TYPE,PARAMETER_MODE
FROM INFORMATION_SCHEMA.PARAMETERS
WHERE SPECIFIC_NAME='AddDefaultPropertyDefinitions'

Hope this would be very useful for developers who are working with database.


Other popular Tips/Tricks
How to ALTER or ADD two columns in Sql Server Table using T-Sql In this tips, I will explain how to ALTER or ADD two or more columns in to table by t-sql script. Published Date : 25/Mar/2011 Tracking Change Data Capture in SQL Server 2008 A very important feature of SQL Server 2008 is that we can enable CDC(Change Data capture) on database or table.We can track the database had CDC enabled by querying IS_CDC_ENABLED column Published Date : 17/Jan/2011 Tracking Change Data Capture in SQL Server 2008 A very important feature of SQL Server 2008 is that we can enable CDC(Change Data capture) on database or table.We can track the database had CDC enabled by querying IS_CDC_ENABLED column Published Date : 17/Jan/2011 How to use DATEDIFF() function in Sql Server This is the third tips date related function in sql server. In this I going to show you how to use DATEDIFF() function in sql server. The DATEDIFF () is useful to get the specified date part between two dates Published Date : 16/Dec/2010 How to get Table and Database size using T-Sql Today I would like to check my database and other few table size in online database. For that I have been use the system produce to get the tables and database size. Published Date : 15/Dec/2010

There is no comments for this articles.