tslb20040515184313.sql

sql版功能齐全

--表'tslb'的结构
  if exists (select * from sysobjects where id = OBJECT_ID('tslb') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE tslb
  CREATE TABLE tslb(ClassID nvarchar (4) not null,ClassName nvarchar (40) null,)
--表'tslb'的数据
  insert into tslb(ClassID,ClassName) Values('0001','文学')
  insert into tslb(ClassID,ClassName) Values('0002','计算机')
  insert into tslb(ClassID,ClassName) Values('0003','军事')
  insert into tslb(ClassID,ClassName) Values('0004','数学')
  insert into tslb(ClassID,ClassName) Values('0005','化学')
  insert into tslb(ClassID,ClassName) Values('0006','地理')