T-SQL语句
本主题适用于：SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
本参考主题总结了使用Transact-SQL的各种语句类型。你可以找到所有列在左边导航中的语句。
备份与还原
The backup and restore statements provide ways to create backups and restore from backups. For more information, see the Backup and restore overview.
数据定义语言
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database.
- ALTER
- Collations
- CREATE
- DROP
- DISABLE TRIGGER
- ENABLE TRIGGER
- RENAME
- UPDATE STATISTICS
数据操纵语言
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
- BULK INSERT
- DELETE
- INSERT
- MERGE
- TRUNCATE TABLE
授权语句
Permissions statements determine which users and logins can access data and perform operations. For more information about authentication and access, see the Security center.
服务代理语句
Service Broker is a feature that provides native support for messaging and queuing applications. For more information, see Service Broker.
会话设置
SET statements determine how the current session handles run time settings. For an overview, see SET statements.