SQL Cheat Sheet and Common Int. Questions Flashcards
- Cover common SQL Syntax - Cover common SQL Int. Questions
1
Q
What are the Data Types of SQL?
A
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
2
Q
What are Joins in SQL? What are all 4 types of joins and what do they do?
A
Joins
