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 |
|
azharrahi
Starting Member
44 Posts |
 Posted - 2006-06-14 : 09:05:36
|
| I want to create a virtual table on a base (real) table such that If i update the virtual table, the base (real) table should not be updated, and it must continue to show only previous values already existed in it.Is it possible in SQL SERVER 2000?. I tried to do it with views but when i updated views the base (real) table was also updated..Azhar RahiSoftware EngineerEye4tech Pvt Ltd,Lahore Pakistan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-14 : 09:20:08
|
| You should not use View. Use other tableMadhivananFailing to plan is Planning to fail |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-14 : 09:30:45
|
| What is a "virtual table"?CODO ERGO SUM |
|
|
|
|
|
|
Updating Virtual Tables without updating base tabl