SQL Server database Add temp table

Select field 1, Field 2, Field 3 into Tempname form table where table.id=1;

This will give the Tempname table an auto-generated field 1, Field 2, field 33 fields, and values.

Modify table field values, according to Nid
Update tablename SET field 1=TB.SSM from (select field as SSM from Table2) TB
where Tbalename.nid=tb.nid

Add a field to a table

ALTER TABLE 1_20150513
Add Field 1 int

ALTER TABLE 1_20150513
Add Field 2 decimal (18,2)

ALTER TABLE 1_20150513
Add Field 3 decimal (18,2)

ALTER TABLE 1_20150513
Add Field 4 decimal (18,2)

ALTER TABLE 1_20150513
Add field 5 varchar (50)

SQL Server database Add temp table