sample190.sql

T-SQL示例大全

/* 文件名称: Sample190.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

SELECT * INTO student FROM stud87
  UNION ALL
SELECT * FROM stud88
  UNION ALL
SELECT * FROM stud89
  ORDER BY name DESC