How to define a temp table in SQL Server?

Question

What are temp tables? What is the difference between global and local temp tables?

Answer 1

A temp table is a temporary storage structure. What does that mean? Basically, you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.

Syntax:

DECLARE @temp TABLE(Column datatype,...)