Sunday, March 25, 2012

create table from another table

In oracle i can do a 'create table xyz as select * from abc'. How do i
accomplish this with sqlserver?
--
Don> In oracle i can do a 'create table xyz as select * from abc'. How do i
> accomplish this with sqlserver?
SELECT *
INTO xyz
FROM abc
Hope this helps.
Dan Guzman
SQL Server MVP

No comments:

Post a Comment