insertdemo7.sql

T-SQL示例大全

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

if exists (select * from dbo.sysobjects where id = object_id(N'AnnualScore') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table AnnualScore
GO

CREATE TABLE AnnualScore
  (grade char(1),class char(2),score decimal(5,2))

GO

INSERT AnnualScore
  SELECT grade,class,AVG(chinese+english)/2
    FROM stud87
    GROUP BY grade,class
    ORDER BY 1,3

INSERT AnnualScore
  SELECT grade,class,AVG(chinese+english)/2
    FROM stud88
    GROUP BY grade,class
    ORDER BY 1,3

INSERT AnnualScore
  SELECT grade,class,AVG(chinese+english)/2
    FROM stud89
    GROUP BY grade,class
    ORDER BY 1,3

GO

SELECT * FROM AnnualScore
  ORDER BY 1,3

GO