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 !=