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 |
|
himali17
Starting Member
8 Posts |
 Posted - 2009-01-13 : 11:52:54
|
| How to fetch just column names from stored procedure in sql 2000? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 12:04:04
|
| column names from procedure? you mean resultset info? |
 |
|
|
himali17
Starting Member
8 Posts |
Posted - 2009-01-13 : 12:21:13
|
| Yes resultset info. |
|
|
|
himali17
Starting Member
8 Posts |
Posted - 2009-01-13 : 12:21:13
|
| Yes resultset info. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 12:52:16
|
| i think you need to look at syscomments system table |
|
|
|
himali17
Starting Member
8 Posts |
Posted - 2009-01-13 : 15:33:09
|
| Thanks for the suggetion but it didnt worked. It works for tables and views but not for stored procedure. Let me know if you have any other way to find out. |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-01-13 : 15:41:04
|
| The columns from a procedure might vary based on the input parameter to the proc. I dont think there is a way to get the column names from stored procedure. |
|
|
|
himali17
Starting Member
8 Posts |
Posted - 2009-01-14 : 09:58:22
|
| Ya.. Anyways thanks for replying. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 10:16:52
|
quote:
Originally posted by himali17
Ya.. Anyways thanks for replying.
it would be much easier if you're using UDF instead of procedure |
|
|
|
|
|
|
Pulling Column Names