db - sql server.sql

来自「SQL Server 2005 对Native XML Web 服务的支持」· SQL 代码 · 共 46 行

SQL
46 行
字号
--USE aida32;

IF exists(select * from sysobjects where id = object_id('Item') and OBJECTPROPERTY(id, 'IsTable') = 1)
DROP TABLE Item;

IF exists(select * from sysobjects where id = object_id('Report') and OBJECTPROPERTY(id, 'IsTable') = 1)
DROP TABLE Report;

IF exists(select * from sysobjects where id = object_id('NextID') and OBJECTPROPERTY(id, 'IsTable') = 1)
DROP TABLE NextID;

CREATE TABLE Report (
  ID          INT IDENTITY (1,1),
  RVersion    VARCHAR(255),
  RHost       VARCHAR(255),
  RUser       VARCHAR(255),
  RLocation   VARCHAR(255),
  RDateTime   VARCHAR(16),
  RComplete   BIT NOT NULL,

  CONSTRAINT  cnstR1 PRIMARY KEY(ID)
);

CREATE TABLE Item (
  ID          INT IDENTITY (1,1),
  IPage       VARCHAR(100),
  IDevice     VARCHAR(255),
  IGroup      VARCHAR(255),
  IField      VARCHAR(255),
  IValue      VARCHAR(255),
  IIcon       INT,
  IID         INT,
  ReportID    INT NOT NULL,

  CONSTRAINT  cnstI1 PRIMARY KEY(ID),
  CONSTRAINT  cnstI2 FOREIGN KEY(ReportID) REFERENCES Report(ID)
);

CREATE TABLE NextID (
  TableName   VARCHAR(6) PRIMARY KEY,
  NextID      INT NOT NULL
);

INSERT INTO NextID (TableName, NextID) VALUES ('Item', 1);
INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?