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 |
|
DRAGON
Starting Member
13 Posts |
 Posted - 2007-03-12 : 04:36:39
|
| Ex. I have a procedure with a select: "Selct A, B, C, D From E".Now when i know the name of that procedure, I want to know what fields in that procedure in system table or sth like that.How can i do that? Please help me!dragon |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-13 : 07:56:14
|
| One way you can see the parameters that a stored procedures uses is with query analyzer. Use the object browser and expand the database to stored procedures. Click on the stored procedure and expand parameters. It will list the parameter and datatypes.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
|
|
|
Finding fields in procedures?