How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

When you use this form, a table is physically created as the statement is executed. The newly created table does not reflect subsequent changes in the underlying tables (in the query-expression). If ...

It is more efficient to omit the ORDER BY clause when you are creating the view and specify it as needed when you reference the view in queries. Note: If you specify the NUMBER option in the PROC SQL ...