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
Sur cette page du site, vous pouvez voir la vidéo en ligne Create Table From SELECT statement | SQL Server Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur The SQL Guy 13 septembre 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 5,437 fois et il a aimé 19 téléspectateurs. Bon visionnage!
