groupuser20040515184313.sql

sql版功能齐全

--表'groupuser'的结构
  if exists (select * from sysobjects where id = OBJECT_ID('groupuser') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE groupuser
  CREATE TABLE groupuser(GroupID char not null,GroupName nvarchar (50) not null,MaxDate smallint not null,MaxNum smallint not null,)
--表'groupuser'的数据
  insert into groupuser(GroupID,GroupName,MaxDate,MaxNum) Values(01,'学生',7,3)
  insert into groupuser(GroupID,GroupName,MaxDate,MaxNum) Values(02,'研究生',10,5)
  insert into groupuser(GroupID,GroupName,MaxDate,MaxNum) Values(03,'教师',30,12)
  insert into groupuser(GroupID,GroupName,MaxDate,MaxNum) Values(04,'教授',45,20)