源文件的内容是
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__PollAnswe__PollI__4316F928]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[PollAnswers] DROP CONSTRAINT FK__PollAnswe__PollI__4316F928
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PollAnswers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PollAnswers]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PollQuestions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PollQuestions]
GOCREATE TABLE [dbo].[PollAnswers] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[PollID] [int] NOT NULL ,
[Answer] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AnswerCount] [int] NULL ,
[AnswerPercent] [int] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[PollQuestions] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Question] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StartDate] [datetime] NULL ,
[EndDate] [datetime] NULL ,
[Active] [int] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__PollAnswe__PollI__4316F928]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[PollAnswers] DROP CONSTRAINT FK__PollAnswe__PollI__4316F928
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PollAnswers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PollAnswers]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PollQuestions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PollQuestions]
GOCREATE TABLE [dbo].[PollAnswers] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[PollID] [int] NOT NULL ,
[Answer] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AnswerCount] [int] NULL ,
[AnswerPercent] [int] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[PollQuestions] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Question] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StartDate] [datetime] NULL ,
[EndDate] [datetime] NULL ,
[Active] [int] NULL
) ON [PRIMARY]
GO
解决方案 »
- ckeditor文本编辑器中编辑的文本如何存入数据库?
- 帮帮忙 JQuery
- 往html音乐播放器添加网络音乐地址总失效为什么呢
- 未能加载文件或程序集“AspWebControl”或它的某一个依赖项
- 关于自定义控件
- 使vb.net的或已经安装上了vb.net的请看过来.
- c#中用&&和&有什么区别呀???为什么把&&改成&程序也可运行??(是一个and运算例子)。还有 | 和 || 的区别??谢谢!!!
- 怎样将asp.net中Session值传给asp页面?
- 帮我看看这段程序,为什么运行时,老说MessageBox未声明??在线等~~
- GridVeiw 更新时不想让有些列显示文本框~~~~!
- 无法在浏览器中直接打开Office文档的问题
- 高手指点:ASP.NET能否实现自动登陆网站
首先新建一个数据库,然后选择TOOLS——SQL Server Query Analyzer,在DB项选择你创建的数据库名,然后选择File——Open,选择你下载的sql.sql文件,确定后点击执行查询,一个三角符号,运行成功的话就可以了