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 |
|
Mpilo
Yak Posting Veteran
52 Posts |
 Posted - 2008-08-14 : 11:35:23
|
| I have a problem i want to update my database e.g i want to change a city name but that old name remain in my database. if want to search that you will find it. |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-14 : 12:22:20
|
| what do you want to happen to the old value?store it somewhere else? or actually insert a new row rather than update it?Em |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-14 : 14:15:26
|
| may be what he wants is a history tracking mechanism when updation happens to main table. if yes,create a history table and a trigger to populate it. |
|
|
|
|
|
|
hi guys