string strSQL = "IF EXISTS (" +
"SELECT * " +
"FROM northwind.dbo.sysobjects " +
"WHERE NAME = 'Picture' " +
"AND TYPE = 'u')" + Environment.NewLine +
"BEGIN" + Environment.NewLine +
"DROP TABLE northwind.dbo.picture" + Environment.NewLine +
"END" + Environment.NewLine +
"CREATE TABLE Picture (" +
"PictureID Int IDENTITY(1,1) NOT NULL," +
"[FileName] Varchar(255) NOT NULL," +
"Picture Image NOT NULL," +
"CONSTRAINT [PK_Picture] PRIMARY KEY CLUSTERED" +
"(PictureID))";上面是判断表是否存在并可创建表的代码,你看后修改一下,应该对你有用处!
"SELECT * " +
"FROM northwind.dbo.sysobjects " +
"WHERE NAME = 'Picture' " +
"AND TYPE = 'u')" + Environment.NewLine +
"BEGIN" + Environment.NewLine +
"DROP TABLE northwind.dbo.picture" + Environment.NewLine +
"END" + Environment.NewLine +
"CREATE TABLE Picture (" +
"PictureID Int IDENTITY(1,1) NOT NULL," +
"[FileName] Varchar(255) NOT NULL," +
"Picture Image NOT NULL," +
"CONSTRAINT [PK_Picture] PRIMARY KEY CLUSTERED" +
"(PictureID))";上面是判断表是否存在并可创建表的代码,你看后修改一下,应该对你有用处!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货