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 |
|
heartly
Starting Member
4 Posts |
 Posted - 2005-06-19 : 22:07:48
|
| i was created two tables. then i also created a view. my view join two tables using primary keys. how can i update the primary key using view...................................... |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-19 : 23:50:30
|
| Update both of the base tables individually.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
heartly
Starting Member
4 Posts |
Posted - 2005-06-20 : 03:54:45
|
| i created a trigger at last...thanks derrickleggett for da helpscreate trigger upmyservice on myserviceinstead of update asupdate service set service_code = scode1 from updatedupdate airline_service set service_code = scode2 from updated |
|
|
|
|
|
|
update data from view