SQL Cheat Sheet and Common Int. Questions

Question 1

What are the Data Types of SQL?

Answer 1

BIT					
TINYINT				
SMALLINT			
BIGINT				
SMALLMONEY			
MONEY				
DECIMAL(20)			
FLOAT(24)			
FLOAT(50)			

CHAR(1)				
NCHAR(1)			
CHAR(50)			
NCHAR(50)			
VARCHAR(50)			
NVARCHAR(50)		
VARCHAR(MAX)		
NVARCHAR(MAX)		
TEXT				
NTEXT				
XML					

SMALLDATETIME		
DATETIME			
DATETIME2			
DATETIMEOFSET		
DATE				
TIME

BINARY(50)
VARBINARY(50)
VARBINARY(MAX)
IMAGE
TIMESTAMP
FILESTREAM
UNIQUEIDENTIFIER
SQL_VARIANT

Question 2

What are Joins in SQL? What are all 4 types of joins and what do they do?

Answer 2

Joins