sample189.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

/* 文件名称: Sample189.sql */
USE 北风贸易
GO

if EXISTS (select * from dbo.sysobjects where id = object_id(N'student') AND
  OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE student
GO

-- 将合并后的结果保存至一个名为 student 的新数据表中
SELECT 姓名 = name,班级 = class,年级 = grade,中文 = chinese,英文 = english
  INTO student FROM stud87
  UNION ALL
SELECT * FROM stud88
  UNION ALL
SELECT * FROM stud89
  ORDER BY 年级,班级,姓名 DESC

-- 查询 student 数据表
SELECT * FROM student