首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

请教以下语句改为C#中的写法

2012-02-20 
请问以下语句改为C#中的写法?DimstrSQLAsString_IFEXISTS( &_SELECT*&_FROMnorthwind.dbo.sysobject

请问以下语句改为C#中的写法?


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)) "

先谢谢了!

[解决办法]
string strSQL= "IF EXISTS ( " + "SELECT * " +..........

[解决办法]
string strSQL =
"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)) ";

热点排行