General discussion

Locked

MSSQL 2000 - Select Column

By michaeltan ·
Anyone know how to use a SQL stmt to auto retrieve the first and second column from a table
(any table)

Select ... , ... from Orders etc

is there column(1) function ?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by michaeltan In reply to MSSQL 2000 - Select Colum ...

Point value changed by question poster.

Collapse -

by toni.myyrylainen In reply to MSSQL 2000 - Select Colum ...

Hi, I'm not quite a sure what you mean "to auto retrieve the first and second column from a table".. You need a query which gets data of the first and the second column from a random table from your database? If this is the case then you need to dig in to the system tables of your db (sysobjects/syscolumns).

Further information can be found from the MS Books Online html-help and it can be downloaded for free (http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx).

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums