How to create a temporary table using the Create statement in SQL Server?

Question

How to create a temporary table is similar to creating a normal table?

Example:

CREATE TABLE table_name 
(
    column1 datatype,
    column2 datatype,
    column3 datatype,
     ....
 );

Answer 1

3 , #. , . @, . "" (, ..), . ## , #, , .

:

declare @table table (id int)
create table #table (id int)
create table ##table (id int)
select * into #table from xyz

Answer 2

, # ##:

CREATE TABLE #TemporaryTable -- Local temporary table
(
    Col1 int,
    Col2 varchar(10)
    ....
);

CREATE TABLE ##GloablTemporaryTable -- Gloabl temporary table - note it starts with ##.
(
    Col1 int,
    Col2 varchar(10)
    ....
);

# ##. - , - .
- , .