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 ...

Once the schema is created, close the SQL Script window. You’re ready to create a table. I’ve created a database called SERVERS, that will be listed in the SCHEMAS pane. Expand that listing ...