SQL Chapter 1 Set 1
SQL
Structured Query Language It is a standard language for accessing and manipulating databases.
bit
Allows 0, 1, or NULL
ANSI
American National Standards Institute SQL is an ANSI standard.
5 DDL statement
CREATE ALTER DROP RENAME TRUNCATE
DDL
Data Definition Language Define the database structure (database schema).
DML
Data Manipulation Language Manage data.
nchar
Fixed width Unicode string. Max 4,000 characters. (defined width x 2)
binary(n)
Fixed width binary string. Max 8,000 characters.
char(n)
Fixed width character string. Max 8,000 characters.
4 DML statements
INSERT where, in/between/like UPDATE and/or DELETE MERGE order by
data retrieval statement
SELECT distinct/top/alias/wildcard
SSMS
SQL Server Management Studio
T-SQL
Transact SQL It extends SQL by adding several features. T-SQL is the query language used in Microsoft SQL Server.
ntext
Variable width Unicode string. Max 2GB.
nvarchar
Variable width Unicode string. Max 4,000 characters.
nvarchar(max)
Variable width Unicode string. Max 536,870,912 characters.
image
Variable width binary string. Max 2GB.
varbinary(max)
Variable width binary string. Max 2GB.
varbinary
Variable width binary string. Max 8,000 characters.
varchar(max)
Variable width character string. Max 1,073,741,824 characters. (2 bytes + number of characters)
text
Variable width character string. Max 2GB. (4 bytes + number of characters)
varchar(n)
Variable width character string. Max 8,000 characters. (2 bytes + number of characters)
<>
not equal in WHERE clause. It may be written as !=
