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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-03 : 08:31:07
|
| Brian writes "I'm looking for a way to have the DBMS return column names from a query that is not a database object using transact SQL. Similar to a SqlDataReader.GetSchemaTable() function in ADO.Net where you can take any valid SQL string, create a SqlCommand object, create a SqlDataReader object and get a list of columns." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-09-03 : 08:32:48
|
| OK, I don't know how they'd be similar since you want to get columns from something that's not a database object, and since SQL really only works on database objects I'm tending to think you're SOL here. |
 |
|
|
|
|
|
Return column names from any query string