TSQL入门（msdn)

数据类型 (Transact-SQL)
Functions (Transact-SQL)
运算符 (Transact-SQL)
系统存储过程 (Transact-SQL)
系统视图 (Transact-SQL)

 

1. 语法：

BULK INSERT (Transact-SQL)

DELETE (Transact-SQL)

EXECUTE (Transact-SQL)

FROM (Transact-SQL)

IDENTITY（属性）(Transact-SQL)

NEWID (Transact-SQL)

SELECT (Transact-SQL)

UPDATE (Transact-SQL)

MERGE (Transact-SQL)

OUTPUT 子句 (Transact-SQL)

 

BETWEEN (Transact-SQL)

CONTAINS (Transact-SQL)

EXISTS (Transact-SQL)

FREETEXT (Transact-SQL)

IN (Transact-SQL)

IS [NOT] NULL (Transact-SQL)

LIKE (Transact-SQL)

搜索条件 (Transact-SQL)

 

保留关键字 (Transact-SQL)

 

2. 示例

SELECT 示例 (Transact-SQL)

INSERT 示例 (Transact-SQL)

WHERE (Transact-SQL)

CREATE TRIGGER (Transact-SQL)