Check out example codes for "create temp table with columns in sql server". It will help you in understanding the concepts better.

Code Example 1

CREATE TABLE employee
(
emp_id INT IDENTITY PRIMARY KEY,
last_name VARCHAR(30) NOT NULL,
first_name VARCHAR(30) NOT NULL,
hire_date DATETIME NOT NULL,
job_title VARCHAR(50) NOT NULL
)

Learn ReactJs, React Native from akashmittal.com