/****** Object: Table [dbo].[Articles] Script Date: 7/8/2003 4:04:33 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Articles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Articles]
GO
/****** Object: Table [dbo].[Articles] Script Date: 7/8/2003 4:04:34 PM ******/
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [varchar] (50) NOT NULL ,
[Author] [varchar] (50) NOT NULL ,
[Description] [varchar] (2000) NOT NULL ,
[DatePublished] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Articles] WITH NOCHECK ADD
CONSTRAINT [PK_Articles] PRIMARY KEY CLUSTERED
(
[ArticleID]
) ON [PRIMARY]
GO
insert into Articles(Title, Author, Description,DatePublished) VALUES('Why ASP.NET is Neat!','Scott Mitchell','This article examines the reasons why ASP.NET in just so neat. Author Scott Mitchell employs the scientific method and advanced mathematical models to conclusively prove ASP.NET is neat.','2003-07-07 00:00:00')
insert into Articles(Title, Author, Description,DatePublished) VALUES('To ASP.NET or Not to ASP.NET?','Jisun Lee','This philosophical article looks at the age-old question, ''To ASP.NET or Not?'' The article traces through metaphysical and epistemological notions of ASP.NET as it attempts to answer this question that has riddled the minds of history''s greatest thinker','2003-07-09 00:00:00')
insert into Articles(Title, Author, Description,DatePublished) VALUES('ASP.NET Manifesto','Karl Engle','In this lengthy manifesto, author Karl Engle spells out his vision for a societal and political utopia, where all the people of the world receive precisely the technology they need. Karl''s manifesto claims that, with ASP.NET, all will be equal technologi','2003-07-09 00:00:00')
insert into Articles(Title, Author, Description,DatePublished) VALUES('Critique of Modern ASP.NET','Bertrand Descartes','This piece, author Bertrand Descartes first, takes a serious look at ASP.NET and the popular beliefs surrounding it. Bertand asks, ''What can we know about ASP.NET if we cannot even know that ASP.NET exists?'' A must read for all aspiring ASP.NET pupils.','2003-07-10 00:00:00')
insert into Articles(Title, Author, Description,DatePublished) VALUES('The ASP.NET Club','Penny Lightweight','Enjoy this romp of a good story about three eleven year old elementary school girls who join together one summer to form an ASP.NET club. Set in an Anywhere, U.S.A., this tale is a delight for all ages.','2003-07-11 00:00:00')
insert into Articles(Title, Author, Description,DatePublished) VALUES('All Quiet on the ASP.NET Front','Eric Yates','This harrowing tale of a young man''s experiences with JSP will shake all readers to the bone and make them ask, ''Why doesn''t everyone use ASP.NET?''','2003-07-11 00:00:00')
insert into Articles(Title, Author, Description,DatePublished) VALUES('Happy ASP.NET','Johnny Maher','Join the Fonz and his gang as they rollic throughout town, living the good life and enjoying ASP.NET.','2003-07-13 00:00:00')
GO
评论3