定义换行字符串时,报语法错误,怎么解决?
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,>)”
这样写的时候会报许多语法错误,我该如何写,难道要这些语句排版到同一行吗???
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,>)”
这样写的时候会报许多语法错误,我该如何写,难道要这些语句排版到同一行吗???
格式://c1数字
insert table(c1,c2,c3) values(1,'2','3')
( <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模板,需要你自己替换掉
...
就是想直接用里面的sql语句的