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.
| Author |
Topic |
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
 Posted - 2002-10-07 : 04:09:49
|
| Hi All,I wonder where I could find sys table where SQL Server 2000 stored information of a parameters expecting from a stored procedure?Thanks in advance.The Rebel |
|
|
ashok
Yak Posting Veteran
57 Posts |
Posted - 2002-10-07 : 04:38:21
|
You should read Books online for stuff like this.if you do a :sp_helptext 'stored_proc_name' you can see the parameters for the procedure |
 |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2002-10-07 : 04:58:52
|
| check syscolumns table |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-07 : 08:42:42
|
| select * from INFORMATION_SCHEMA.PARAMETERS where SPECIFIC_NAME='stored procedure name'HTHJasper Smith |
|
|
|
|
|
|
Stored Procedure Parameter