Input Parameters os Sp - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Input Parameters os Sp

Author

Topic

ranganath
Posting Yak Master

209 Posts

Posted - 2007-10-22 : 00:46:47

Hi

Iam giving Input parameter as 'Storedprocedurename'

I want to Get Input Parameters, DataType, and their length of That
stored procedure

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-10-22 : 00:56:10

sp_help Storedprocedurename

KH
[spoiler]Time is always against us[/spoiler]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-10-22 : 01:02:06

SELECT 	c.colid, c.name, c.xtype, t.name, c.length, c.prec, c.scale
FROM 	syscolumns c
	INNER JOIN master..systypes t
	ON	c.xtype	= t.xtype
WHERE 	c.id = object_id('Storedprocedurename')

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-22 : 02:53:15

Also read about Information_schema.parameters in sql server help file

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources