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 |
|
jacintha
Starting Member
3 Posts |
 Posted - 2008-07-03 : 00:04:01
|
| I need to add a new column to the result set and this new column is not a part of the result set.How can i do it?Anyone can plz help me out...Thanks,jessy |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-03 : 00:07:16
|
just add it in like thisselect old_col1, old_col2, old_col3, new_colfrom some_table
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
jacintha
Starting Member
3 Posts |
Posted - 2008-07-06 : 23:07:08
|
| this gives an error telling "invalid column name".Anyways, I got d answer myself..Thanks for ur reply..jessy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 02:15:15
|
quote:
Originally posted by jacintha
this gives an error telling "invalid column name".Anyways, I got d answer myself..Thanks for ur reply..jessy
that was just an illustration, you need to replace it with your column name. UNless you give more info we can give only such generic solutions. please keep in mind that we dont have access to your system and dont know your table structures. |
|
|
|
|
|
|
Reg adding a new column in the result set