Once the table is created, you can perform INSERT, UPDATE, DELETE, and SELECT statements on the table as you would with any regular table. How do SQL Server Temp Tables Work?