Page 51 - SQL

SQL Server

To create a temporary table local to the session:

CREATE TABLE #TempPhysical(...);

To create a temporary table visible to everyone:

CREATE TABLE ##TempPhysicalVisibleToEveryone(...);

To create an in-memory table:

DECLARE @TempMemory TABLE(...);

Read CREATE TABLE online: https://riptutorial.com/sql/topic/348/create-table

https://riptutorial.com/ 33