好博客网asp.net

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[USERS]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[USERS]( [uID] [char](5) NOT NULL, [uName] [varchar](30) NOT NULL, [uPwd] [varchar](20) NOT NULL, [uPhoto] [varchar](40) NULL, PRIMARY KEY CLUSTERED ( [uID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NEWS]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[NEWS]( [nID] [int] IDENTITY(1,1) NOT NULL, [nTilte] [varchar](30) NOT NULL, [nBody] [text] NULL, [nAuthor] [varchar](30) NOT NULL, [nDT] [datetime] NULL, PRIMARY KEY CLUSTERED ( [nID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END