日韩无码专区无码一级三级片|91人人爱网站中日韩无码电影|厨房大战丰满熟妇|AV高清无码在线免费观看|另类AV日韩少妇熟女|中文日本大黄一级黄色片|色情在线视频免费|亚洲成人特黄a片|黄片wwwav色图欧美|欧亚乱色一区二区三区

RELATEED CONSULTING
相關(guān)咨詢
選擇下列產(chǎn)品馬上在線溝通
服務(wù)時(shí)間：8:30-17:00
你可能遇到了下面的問題
關(guān)閉右側(cè)工具欄

新聞中心

這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
SQL中if語句的用法示例

SQL中if語句是最常見也是最常用的SQL語句之一，下面就將為您舉例說明SQL中if語句的用法，希望對(duì)您學(xué)習(xí)SQL中if語句的使用能夠有些許幫助。

創(chuàng)新互聯(lián)專注于綠春企業(yè)網(wǎng)站建設(shè),成都響應(yīng)式網(wǎng)站建設(shè)公司,商城建設(shè)。綠春網(wǎng)站建設(shè)公司,為綠春等地區(qū)提供建站服務(wù)。全流程定制網(wǎng)站開發(fā)，專業(yè)設(shè)計(jì)，全程項(xiàng)目跟蹤，創(chuàng)新互聯(lián)專業(yè)和態(tài)度為您提供的服務(wù)

 
 
 
    
  
  
  
  1. _sql = " if not exists (select * from ProDesignSheet5 where Sheet5ID = '" + this.Sheet5id + "') " 
    2. 
  
  
  
  2.               + " insert into ProDesignSheet5 values('" + this.Sheet5id 
    3. 
  
  
  
  3.               + "','" + this.Consplacepbfee.ToString() 
    4. 
  
  
  
  4.               + "','" + this.Searchtestfee.ToString() 
    5. 
  
  
  
  5.               + "','" + this.Ccdesignfee.ToString() 
    6. 
  
  
  
  6.               + "','" + this.Propreparefee.ToString() 
    7. 
  
  
  
  7.               + "','" + this.Elecfee.ToString() 
    8. 
  
  
  
  8.               + "','" + this.Workerdqfee.ToString() 
    9. 
  
  
  
  9.               + "','" + this.Cjzpgdqfee.ToString() 
    10. 
  
  
  
  10.               + "','" + this.Dxsgjxdqfee.ToString() 
    11. 
  
  
  
  11.               + "','" + this.Debzglfee.ToString() 
    12. 
  
  
  
  12.               + "','" + this.Jsqtzdkrate.ToString() 
    13. 
  
  
  
  13.               + "','" + this.Gczljdfee.ToString() 
    14. 
  
  
  
  14.               + "','" + this.Yuntufee.ToString() 
    15. 
  
  
  
  15.               + "','" + this.Jfgzjgzfee.ToString() 
    16. 
  
  
  
  16.               + "','" + this.Wsdyrfee.ToString() 
    17. 
  
  
  
  17.               + "','" + this.Whclfee.ToString() 
    18. 
  
  
  
  18.               + "','" + this.Bgyffee.ToString() 
    19. 
  
  
  
  19.               + "','" + this.Yytfee.ToString() 
    20. 
  
  
  
  20.               + "','" + this.Hlhtfee.ToString() 
    21. 
  
  
  
  21.               + "','" + this.Jfxtfee.ToString() 
    22. 
  
  
  
  22.               + "','" + this.Ybgjfee.ToString() 
    23. 
  
  
  
  23.               + "','" + this.Gxzfzfee.ToString() 
    24. 
  
  
  
  24.               + "','" + this.Lyglfee.ToString() 
    25. 
  
  
  
  25.               + "','" + this.Jfzjfee.ToString() 
    26. 
  
  
  
  26.               + "','" + this.Gdzjfee.ToString() 
    27. 
  
  
  
  27.               + "','" + this.Gdlxlzjfee.ToString() 
    28. 
  
  
  
  28.               + "','" + this.Workteamfee.ToString() 
    29. 
  
  
  
  29.               + "','" + this.Condeptfee.ToString() 
    30. 
  
  
  
  30.               + "','" + this.Tower.ToString() 
    31. 
  
  
  
  31.               + "','" + this.Servicefee.ToString() 
    32. 
  
  
  
  32.               + "','" + this.Checkfee.ToString() 
    33. 
  
  
  
  33.               + "','" + this.Other.ToString() 
    34. 
  
  
  
  34.               + "','" + this.ItemNum.ToString() 
    35. 
  
  
  
  35.               + "','" + this.ItemName.ToString() 
    36. 
  
  
  
  36.               + "','" + this.PassId.ToString() 
    37. 
  
  
  
  37.               + "')" 
    38. 
  
  
  
  38.               + " else update ProDesignSheet5 set Consplacepbfee='" + this.Consplacepbfee.ToString() 
    39. 
  
  
  
  39.               + "',Searchtestfee='" + this.Searchtestfee.ToString() 
    40. 
  
  
  
  40.               + "',Ccdesignfee='" + this.Ccdesignfee.ToString() 
    41. 
  
  
  
  41.               + "',Propreparefee='" + this.Propreparefee.ToString() 
    42. 
  
  
  
  42.               + "',Elecfee='" + this.Elecfee.ToString() 
    43. 
  
  
  
  43.               + "',Workerdqfee='" + this.Workerdqfee.ToString() 
    44. 
  
  
  
  44.               + "',Cjzpgdqfee='" + this.Cjzpgdqfee.ToString() 
    45. 
  
  
  
  45.               + "',Dxsgjxdqfee='" + this.Dxsgjxdqfee.ToString() 
    46. 
  
  
  
  46.               + "',Debzglfee='" + this.Debzglfee.ToString() 
    47. 
  
  
  
  47.               + "',Jsqtzdkrate='" + this.Jsqtzdkrate.ToString() 
    48. 
  
  
  
  48.               + "',Gczljdfee='" + this.Gczljdfee.ToString() 
    49. 
  
  
  
  49.               + "',Yuntufee='" + this.Yuntufee.ToString() 
    50. 
  
  
  
  50.               + "',Jfgzjgzfee='" + this.Jfgzjgzfee.ToString() 
    51. 
  
  
  
  51.               + "',Wsdyrfee='" + this.Wsdyrfee.ToString() 
    52. 
  
  
  
  52.               + "',Whclfee='" + this.Whclfee.ToString() 
    53. 
  
  
  
  53.               + "',Bgyffee='" + this.Bgyffee.ToString() 
    54. 
  
  
  
  54.               + "',Yytfee='" + this.Yytfee.ToString() 
    55. 
  
  
  
  55.               + "',Hlhtfee='" + this.Hlhtfee.ToString() 
    56. 
  
  
  
  56.               + "',Jfxtfee='" + this.Jfxtfee.ToString() 
    57. 
  
  
  
  57.               + "',Ybgjfee='" + this.Ybgjfee.ToString() 
    58. 
  
  
  
  58.               + "',Gxzfzfee='" + this.Gxzfzfee.ToString() 
    59. 
  
  
  
  59.               + "',Lyglfee='" + this.Lyglfee.ToString() 
    60. 
  
  
  
  60.               + "',Jfzjfee='" + this.Jfzjfee.ToString() 
    61. 
  
  
  
  61.               + "',Gdzjfee='" + this.Gdzjfee.ToString() 
    62. 
  
  
  
  62.               + "',Gdlxlzjfee='" + this.Gdlxlzjfee.ToString() 
    63. 
  
  
  
  63.               + "',Workteamfee='" + this.Workteamfee.ToString() 
    64. 
  
  
  
  64.               + "',Condeptfee='" + this.Condeptfee.ToString() 
    65. 
  
  
  
  65.               + "',Tower='" + this.Tower.ToString() 
    66. 
  
  
  
  66.               + "',Servicefee='" + this.Servicefee.ToString() 
    67. 
  
  
  
  67.               + "',Checkfee='" + this.Checkfee.ToString() 
    68. 
  
  
  
  68.               + "',Other='" + this.Other.ToString() 
    69. 
  
  
  
  69.               //+ "',ItemNum='" + this.ItemNum.ToString() 
    70. 
  
  
  
  70.               //+ "',ItemName='" + this.ItemName.ToString() 
    71. 
  
  
  
  71.               //+ "',PassId='" + this.PassId.ToString() 
    72. 
  
  
  
  72.               + "' where Sheet5id ='" + this.Sheet5id + "'"; 
    73.

當(dāng)前題目：SQL中if語句的用法示例
網(wǎng)站網(wǎng)址：http://www.5511xx.com/article/djcpgeg.html