定义换行字符串时,报语法错误,怎么解决?
string sql=“INSERT INTO [gishc].[dbo].[HC_registerMain]
           ([checkupCode]
           ,[tubeCode]
           ,[personId]
           ,[regDate]
           ,[checkupDate]
           ,[groupCharge]
           ,[charged]
           ,[done]
           ,[phototaken]
           ,[checkupType]
           ,[callingId]
           ,[schemeId]
           ,[checkupScheme]
           ,[workState]
           ,[serviceLength]
           ,[workKindId]
           ,[badFactor]
           ,[dept]
           ,[workno]
           ,[phone]
           ,[password]
           ,[checkupResult]
           ,[doctorAdvice]
           ,[mainDoctor]
           ,[outCheckupCode]
           ,[outCheckupMachine]
           ,[judgeDate]
           ,[locked]
           ,[isprint]
           ,[isRecheck]
           ,[status]
           ,[created_by]
           ,[createdtime]
           ,[modified_by]
           ,[modifiedtime]
           ,[modqty]
           ,[corpDebtId])
     VALUES
           (<checkupCode, varchar(50),>
           ,<tubeCode, varchar(50),>
           ,<personId, int,>
           ,<regDate, smalldatetime,>
           ,<checkupDate, smalldatetime,>
           ,<groupCharge, bit,>
           ,<charged, bit,>
           ,<done, int,>
           ,<phototaken, bit,>
           ,<checkupType, int,>
           ,<callingId, int,>
           ,<schemeId, int,>
           ,<checkupScheme, varchar(100),>
           ,<workState, int,>
           ,<serviceLength, float,>
           ,<workKindId, int,>
           ,<badFactor, varchar(200),>
           ,<dept, varchar(50),>
           ,<workno, varchar(50),>
           ,<phone, varchar(50),>
           ,<password, varchar(64),>
           ,<checkupResult, varchar(1000),>
           ,<doctorAdvice, varchar(1000),>
           ,<mainDoctor, varchar(50),>
           ,<outCheckupCode, varchar(20),>
           ,<outCheckupMachine, varchar(50),>
           ,<judgeDate, smalldatetime,>
           ,<locked, bit,>
           ,<isprint, bit,>
           ,<isRecheck, bit,>
           ,<status, int,>
           ,<created_by, nvarchar(256),>
           ,<createdtime, datetime,>
           ,<modified_by, nvarchar(256),>
           ,<modifiedtime, datetime,>
           ,<modqty, int,>
           ,<corpDebtId, int,>)”
这样写的时候会报许多语法错误,我该如何写,难道要这些语句排版到同一行吗???

解决方案 »

  1.   

    加个@string sql=@“INSERT INTO [gishc].[dbo].[HC_registerMain] 
      

  2.   

    服了你了,先看书打点小基础行不?
    格式://c1数字
    insert table(c1,c2,c3) values(1,'2','3')
      

  3.   

    VALUES
              ( <checkupCode, varchar(50),>
              , <tubeCode, varchar(50),>
              , <personId, int,>
              , <regDate, smalldatetime,>
              , <checkupDate, smalldatetime,>
              , <groupCharge, bit,>
              , <charged, bit,>
              , <done, int,>
              , <phototaken, bit,>
              , <checkupType, int,>
              , <callingId, int,>
              , <schemeId, int,>
              , <checkupScheme, varchar(100),>
              , <workState, int,>
              , <serviceLength, float,>
              , <workKindId, int,>
              , <badFactor, varchar(200),>
              , <dept, varchar(50),>
              , <workno, varchar(50),>
              , <phone, varchar(50),>
              , <password, varchar(64),>
              , <checkupResult, varchar(1000),>
              , <doctorAdvice, varchar(1000),>
              , <mainDoctor, varchar(50),>
              , <outCheckupCode, varchar(20),>
              , <outCheckupMachine, varchar(50),>
              , <judgeDate, smalldatetime,>
              , <locked, bit,>
              , <isprint, bit,>
              , <isRecheck, bit,>
              , <status, int,>
              , <created_by, nvarchar(256),>
              , <createdtime, datetime,>
              , <modified_by, nvarchar(256),>
              , <modifiedtime, datetime,>
              , <modqty, int,>
              , <corpDebtId, int,>)” 把里是sql模板,需要你自己替换掉
      

  4.   

     string sql= @“INSERT INTO [gishc].[dbo].[HC_registerMain]
    ...
      

  5.   

    这个我知道。
    就是想直接用里面的sql语句的