Dim strSQL As String = _
"IF EXISTS (" & _
"SELECT * " & _
"FROM northwind.dbo.sysobjects " & _
"WHERE NAME = 'Picture' " & _
"AND TYPE = 'u')" & vbCrLf & _
"BEGIN" & vbCrLf & _
"DROP TABLE Northwind.dbo.picture" & vbCrLf & _
"END" & vbCrLf & _
"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))"先谢谢了!
"IF EXISTS (" & _
"SELECT * " & _
"FROM northwind.dbo.sysobjects " & _
"WHERE NAME = 'Picture' " & _
"AND TYPE = 'u')" & vbCrLf & _
"BEGIN" & vbCrLf & _
"DROP TABLE Northwind.dbo.picture" & vbCrLf & _
"END" & vbCrLf & _
"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))"先谢谢了!
"IF EXISTS (" +
"SELECT * " +
"FROM northwind.dbo.sysobjects " +
"WHERE NAME = 'Picture' " +
"AND TYPE = 'u')\r\n" +
"BEGIN\r\n" +
"DROP TABLE Northwind.dbo.picture\r\n" +
"END\r\n" +
"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))";
谢谢!