February 03, 2003
Oracle v SQL Server, Part 8
When creating a table in Oracle, instead of specifying the column definitions you can specify an SQL query. This is really useful when cloning tables (and their contents) or creating partitions of large tables.
If anyone knows how to do this in SQL Server I would love to hear about it.
Update: Bermo gives the solution in the comments at the bottom of this post, use SELECT ... INTO. Thanks.
Posted by Andy Todd at February 03, 2003 10:31 AM