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 |
|
lst24
Starting Member
1 Post |
 Posted - 2009-03-19 : 10:27:34
|
| Hi:how can i build a tsql script for review one stored procedure and find the resultset and the field name for the return fields in that procedure.for example if i have one procedure called getMyClients, and when i run that procedure that returns two columns named client_id and client_Name...now i want build a tsql script for review inside that procedure and find those columns named client_id and client_Name, and find also that table name for those colums (i don't want find the results of query, i want just the columns names) |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-03-19 : 10:38:26
|
| sp_helptext <<procedure_name>>Karthik |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-19 : 10:44:05
|
| do you mean taking metadata info or procedure resultset? |
|
|
|
|
|
|
TSQL