Create Table From SELECT statement | SQL Server Tutorial

In this tutorial we look at how to create a SQL table from a SELECT statement.

Benefits

Its a really handy method if you want to duplicate a table structure, its seen sometimes with staging tables or as an alternative to temp tables and table variables. Personally I've only seen it used within stored procedures. Its a quick method to create a table rather than creating all the data types.

A big benefit is sometime where you just want some of the data from table a placed into table b. Maybe you might be recovering data for example

Is it good practice

In reality, its better practice to just create a table properly if you want a static table, if you only needed it temporarily, then I'd suggest using temp tables or table variables

Content

00:00 Introduction
00:27 Create table from SELECT
01:12 Primary Keys and constraints
01:54 Creating Table Objects
02:28 Inserting filtered data

Видео Create Table From SELECT statement | SQL Server Tutorial канала The SQL Guy