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-23 : 13:33:00
|
| Hi All,How can i create a table based on a query ?i tried with the CREATE Table syntax got several errors?is there any body that has the correct sysntax or an example?thanks |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-23 : 13:37:46
|
| use select into construction instead of create tableThanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-03-23 : 14:57:17
|
| HI,Is not "select into " to create a new query only.i need to create a table from a query..is this the same thing ?thanks |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-23 : 15:24:55
|
| Select Into is to create a table. Try looking in BOL if its not clear. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-03-23 : 16:35:52
|
| Thanks this works from table to table. but from view to table ?should i have to specify the "[view]".Also is my table gonna be updated automatically as soon as my View changes.?thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-03-23 : 20:31:10
|
| hi thansk again for the reply.i mean is when the view content changes ( i.e record added) the table content will change too.thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How to create a table from querry ( querry table)