From a logical viewpoint, your request doesn't make sense. If you don't know
the name of the column, then you aren't familiar with the database, and that
would imply that you are a hacker, rather than an authorized user of the
However, assuming you at least know the name of the table, you can get
information about the table, including the column names, via the sp_help
system stored procedure. Documentation on the sp_help system stored
procedure is available in the SQL Server Books Online.
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:> How do you "select" data from a specific column when you know only
> sure of the column name? (using %...)
I am using databases. I am cataloging movies. If I started typing "Arma" how Also. I am getting an error that says that the Dataset is not in Insert or
can I get it to finish typing in "geddon" for me?
Edit mode, and a Key Access Violation Error? I am using Delphi 3 on a
Windows 95 system. Can anyone offer any ideas on why I am getting this and
what I can do about it?
Also. I am getting an error that says that the Dataset is not in Insert or