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 |
|
korssane
Posting Yak Master
104 Posts |
 Posted - 2009-03-25 : 10:08:28
|
| Hi All, I want to know how to make a query table in sql 2005.I have query already created and want to use it as a table.i know that i can use:SELECT *INTO Table1FROM View1WHERE...But this statement allows me to create a table from a view omluy.what i want is how can i update the table1 automatically ( only content not the shema) as soon as the query is updated?Thanks |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-25 : 10:59:02
|
| looks like you are talking about materialized view...Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-25 : 13:12:39
|
| how will you be updating query? where will this query be executed? |
|
|
|
|
|
|
How to : Make a query table