Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay_jadam
Yak Posting Veteran
53 Posts |
 Posted - 2005-10-17 : 00:58:13
|
| hi I m using sql serverwhat exactly i want is that my table contains n fields(i don't know how many)i know the name of first two fields, let's say id and Scodenow i want to get all records but not these two fields, my result should show n-2 fields.Thanks in Advance |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
sanjay_jadam
Yak Posting Veteran
53 Posts |
Posted - 2005-10-17 : 03:44:34
|
| ThanksI got my result but Is there any simple way to do this.RegardsSanjay Jadam |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-17 : 03:58:43
|
| >>Is there any simple way to do this.I dont think soWhat difficulty do you face?MadhivananFailing to plan is Planning to fail |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-10-17 : 04:02:16
|
| I think this is a easier way. Any way if you want to access column names you have to go through information schema.Karunakaran |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-17 : 04:05:55
|
>>you want to access column names you have to go through information schema.Thats what I did in that Link  MadhivananFailing to plan is Planning to fail |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-10-17 : 04:28:49
|
quote:
Originally posted by madhivanan
>>you want to access column names you have to go through information schema.Thats what I did in that Link MadhivananFailing to plan is Planning to fail
Yes, I saw that....you want to access column names you have to go through information schema.That statement is for Sanjay..Karunakaran |
|
|
|
|
|
|
SQL Query result(Urgent)