第一节SQL概述 第二节数据定义功能 第三节数据操纵功能 第四节数据查询功能

SQL Server 2000 实用教程_第13章 SQL Server 的数据仓库

查询课程信息,根据用户需要修改某些元组的 TEACHER字段 EXEC SQL BEGIN DECLARE SECTION /*说明宿主变量dept, deptname,Hcno, CName, TEacher,New Teacher * EXEC SQL END DECLARE SECTION gets(dept); deptname=)” strcat(deptname, dept) strcat(deptname, 1%1)

▪ Accessing SQL From a Programming Language ▪ Functions and Procedures ▪ Triggers ▪ Recursive Queries ▪ Advanced Aggregation Features

SQL Server 2000 实用教程_第5章 SQL Server 2000数据库表的创建和管理

Accessing SQL From a Programming Language Functions and Procedural Constructs Triggers Recursive Queries Advanced Aggregation Features OLAP

Join Expressions Views Transactions Integrity Constraints SQL Data Types and Schemas Authorization

Overview of The SQL Query Language Data Definition Basic Query Structure Additional Basic Operations Set Operations Null Values Aggregate Functions Nested Subqueries Modification of the Database

SQL Server 2000 实用教程_第4章 SQL Server 2000数据库创建与管理

SQL Server 2000 实用教程_第3章 SQL Server 2000数据类型