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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment