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
Showing posts with label questionis. Show all posts
Showing posts with label questionis. Show all posts
Monday, March 19, 2012
Subscribe to:
Posts (Atom)