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
On this page of the site you can watch the video online Create Table From SELECT statement | SQL Server Tutorial with a duration of hours minute second in good quality, which was uploaded by the user The SQL Guy 13 September 2022, share the link with friends and acquaintances, this video has already been watched 5,437 times on youtube and it was liked by 19 viewers. Enjoy your viewing!
