SELECT INTO

SELECT INTO is used to insert selected data into a new database (even a temp one.) Let’s say…

CREATE TABLE #temp
(
NUMBER INT,
NAME VARCHAR(1)
)

INSERT INTO #temp
VALUES
(1,'a'), (1,'a'), (1,'b'),(2,'a'),
(2,'b'),(2,'b'), (1,'c'),(2,'c')

CREATE TABLE #temp

(

NUMBER INT,

NAME VARCHAR(1)

)

INSERT INTO #temp

VALUES

(1,'a'), (1,'a'), (1,'b'),(2,'a'),

(2,'b'),(2,'b'), (1,'c'),(2,'c')

Then…

SELECT *
INTO #temp2
FROM #temp

SELECT * 
FROM #temp2

SELECT *

INTO #temp2

FROM #temp

SELECT *

FROM #temp2

NUMBER	NAME
1	a
1	a
1	b
2	a
2	b
2	b
1	c
2	c

NUMBER NAME

1 a

1 b

2 a

2 b

1 c

2 c