SELECT * INTO TEST2 FROM ...
- Not the construction table in SQL Server, if you want to copy the table, use create table .. as select ...
You can use SELECT XX INTO BB FROM ... to store a piece value into variables