I have a sql statement ,But I don't know the column before I run the sql,its means the sql is black box ,I know nothing in it ,before open it.,
So would you like tell me how to resolve the issue.
Hi everyone ,there is a big question I got on how to resovle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 07, 2012 2:28 am
- Location: China BeiJing
Hi everyone ,there is a big question I got on how to resovle
Dong Ying Ying Come on.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 35
- Joined: Tue Feb 07, 2012 2:28 am
- Location: China BeiJing
Hi Ray ,we don't sure.the early ,I think it simple ,I change the row to column because the sql result only one row,yes it is. so I use the union word to change the sql .after all,I found there are some join or group ,so then my menthods is not correctly .
then I back to the source point .try to find a way the sql run first and then columns not needed ! but this is only my think , I don't know how to do .
then I back to the source point .try to find a way the sql run first and then columns not needed ! but this is only my think , I don't know how to do .
Dong Ying Ying Come on.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Posting the sql involved should help. Are you saying that you don't know the "columns not needed" because it does a select * rather than specifically naming the ones that are needed?dongyingying wrote:try to find a way the sql run first and then columns not needed !
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers