I’m choosing the AdventureWorksLT sample database as the source (Figure B). The next step is to create a server to host your SQL database. In the Server section, click the button to Create a new ...

This method isn't ANSI-standard SQL, but Microsoft's Transact-SQL extension includes this handy feature. Creating a new table from query results can help you build a database of your clients ...