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 |
|
samsun125
Yak Posting Veteran
63 Posts |
 Posted - 2009-10-10 : 03:32:08
|
| Hi All,I have 2 databases 1.A 2.Bin A database i have one view(Aview),in this Aview i have 159 records was there .in B database i have one view (Bview), in this Bview i have 130 records was there .how to copy values from one database view to another database view.RegardsRama |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-10 : 03:37:46
|
you have to provide more detail information . . .What do you mean exactly by copy values from one view to another ?Views is not a physical table. The records are not stored in the view but in the based table of the view. View is just a stored query from one or several tables.Depending on your view, you may not be able to insert record into the view. Most probably you will need to select the records from one database and insert into the based table of the view in the second database.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-11 : 14:42:23
|
| Even if you want to edit through view, you need to understand how the view is defined and how it retrieves data from main table. can you post your scenario with some sample data in below format?http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|
|
how to copy values from one view to another view?