[dba-SQLServer] SQL Server 2005 - View to table

jwcolby jwcolby at colbyconsulting.com
Fri Nov 23 11:04:22 CST 2007


Indeed why not?  The only real reason is that newTable does not exist yet
and I would have to create it by hand. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Friday, November 23, 2007 11:23 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL Server 2005 - View to table

Um, why not just SELECT INTO newTable FROM viewName?

Arthur




More information about the dba-SQLServer mailing list