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 2000 Forums
 Transact-SQL (2000)
 reg column names

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-21 : 06:37:30
venu writes "I have one stored procedure it return the some rows.
How i know the coulmn names for those rows in by using query?"

ojn.
Starting Member

10 Posts

Posted - 2003-02-21 : 13:24:50
There isn't a query that would do this for you. Consider this little sproc, what would you expect to get as the column names...

e.g.
create proc _usp
@i int
as
if @i=1
exec('select 1 as i')
if @i=3
select * from northwind..orders
if @i=99
select current_timestamp

go


--
-oj
www.rac4sql.net
Go to Top of Page
   

- Advertisement -