SQL语句太长我想分行，用什么连接符阿？
例如这句                 string   cmd3   =   "Update   KHGL_Customer   set   cCusCode=@cCusCode,cCusName=@cCusName,cCusAbbName=@cCusAbbName,iDCID=@iDCID,cCusAddressMX=@cCusAddressMX,cCusSJName=@cCusSJName   where   iCustomerId= "   +   Temp;
我想把它从中间断开分两行写，中间用什么连接符阿？

------解决方案--------------------
string cmd3 = "Update KHGL_Customer set CusCode=@cCusCode,cCusName=@cCusName, " +
"cCusAbbName=@cCusAbbName,iDCID=@iDCID,cCusAddressMX=@cCusAddressMX, " +
"cCusSJName=@cCusSJName where iCustomerId= " + Temp;

------解决方案--------------------
// OR

string cmd3 = @ "Update KHGL_Customer set
cCusCode=@cCusCode,cCusName=@cCusName,cCusAbbName=@cCusAbbName,
iDCID=@iDCID,cCusAddressMX=@cCusAddressMX,cCusSJName=@cCusSJName
where iCustomerId= " + Temp;
------解决方案--------------------
" "+
" "+
" "
------解决方案--------------------
string cmd3 = "Update KHGL_Customer set "+
" cCusCode=@cCusCode,cCusName=@cCusName, "+
" cCusAbbName=@cCusAbbName, "+
" iDCID=@iDCID,cCusAddressMX=@cCusAddressMX, "+
" cCusSJName=@cCusSJName where iCustomerId= " + Temp;

------解决方案--------------------
string cmd3 = "Update KHGL_Customer set CusCode=@cCusCode,cCusName=@cCusName, ";
cmd3 += "cCusAbbName=@cCusAbbName,iDCID=@iDCID,cCusAddressMX=@cCusAddressMX, "
cmd3 += "cCusSJName=@cCusSJName where iCustomerId= " + Temp;
------解决方案--------------------
" "+
" "+
" "
或者StringBuild.Append()吧
------解决方案--------------------
string cmd3 = @ "Update KHGL_Customer set
cCusCode=@cCusCode,cCusName=@cCusName,cCusAbbName=@cCusAbbName,
iDCID=@iDCID,cCusAddressMX=@cCusAddressMX,cCusSJName=@cCusSJName
where iCustomerId= " + Temp;


在双引号外加前导@符号允许你直接在字符串中间输入回车,不需要什么来连接.


至于用加号连接, 连加 比每次 += 要好,因为连加多个字符串 "常 "量时,最终生成的IL实际上是优化完直接赋值的,但用+= 就会造成多生成额外的IL