Monday, March 19, 2012

Exclude columns from a select statement

Hi,
Simple question:
Is there any way to exclude some columns with a SELECT Table1.* statement?
Thanks for any infosnope.
You can name the columns that you wish to return or create a dynamic sql statement with the columns in.

It is considered bad practise to use select * for returning data.|||For example:

table collums: id - name - adress - phone

If you wish select only name you can use the following query:

"SELECT name FROM table"

To add new collums you must add it and put behind a "," like:

"SELECT name,phone FROM table"

[ ]'s|||Hi,

In fact, I've an HUGE view with many column and i have to select all the fields without the description ones for a translation process. I'm forced to use SELECT Col1, Col2 ,,,,,, Col30... FROM View.

If a such notation exist I just have to write SELECT all appart(Col20,Col22,Col25) FROM View

Thanks anyway for answers

No comments:

Post a Comment