sql query doute

[GokulGKM]

hi,

        i am using data base sql server in labview.i want select all data from table except some.using the following query but not working.

SELECT *(EXCEPT Column2) FROM Tablename;

SELECT * [except Column2] FROM Tablename;

select * from Tablename except(Column2);

select * from Tablename EXEC(Column2);

select * from Tablenameexcept(Column2);

select * from TablenameEXEC(Column2);

select * FROM TablenameWHERE FIELD NOT IN ('Column2');

[UliB]

Hi,

I use something like this

SELECT col1, col3, col4
  FROM Tablename;

UliB

[mikeporter]

Unfortunately, you can't define your own syntax in SQL. If you want just certain columns from a table you have to list the ones you want. If creating this list is too onerous because the list is large, you have a more fundamental problem: a bad database design.

Mike...

[GokulGKM]

hi,

      i know this but my column is more than 100.so i form query this type too long that y i am try onther methode.

[mikeporter]

What you need to be doing is fixing your database design. Having 100+ columns in a table is absurd! Other than you and your software, how many other users access this database?

Mike...

[jcarmody]

Sometimes you inherit a non-normalized database and need to take baby-steps in the process of repairing it.  This'll build a query with all columns except one.

[GokulGKM]

hi,

       my field record is more than 1000.so i will use this methode take more time.that y i am asking any sql query.. 

[Dennis_Knutson]

So instead of 100 columns like you originally said, you are now saying you have 1000+ columns?