Click the Start button and launch the Microsoft SQL Server Management Studio ... Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table ...

SQL Server Management Studio (SSMS ... then in the object explorer pane drill down and highlight a container, such as Tables. Then click View => Object Explorer Details from the top menu bar.

Sound complicated? It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table containing a subset of records from a larger table. For example ...