12-29-2015 05:00 AM
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');
12-29-2015 05:35 AM
Hi,
I use something like this
SELECT col1, col3, col4
FROM Tablename;
UliB
12-29-2015 08:47 PM
12-29-2015 10:36 PM
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.
12-30-2015 02:58 AM
12-30-2015 05:42 AM
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.
12-31-2015 01:21 AM
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..
12-31-2015 07:02 AM