PCB MS SQL SERVER 欄位含小寫字母更新為大寫字母

標籤：and   導致   jpg   sele   src   分享   ima   批次更新   tde   

今天在預審完成時報如下錯誤，此錯誤原因是由於SQL Server資料欄位存在小寫，而Oracle資料庫需大寫導致的，

 

怎麼解決這個問題了，非常簡單 。這裡將SQL貼出來 .

1.將生產型號中含有小寫字母的查出來--只過濾硬板，FPC不包含在內

--將生產型號中含有小寫字母的查出來--只過濾硬板，FPC不包含在內SELECT * FROM mktxhglb WHERE pdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin AND LEN(pdctno) = 10SELECT * FROM mktdelivery WHERE pdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin  AND LEN(pdctno) = 10SELECT * FROM mkthtpsb WHERE pdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin  AND LEN(pdctno) = 10SELECT * FROM ppeecnxhb WHERE Newpdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin  AND LEN(Newpdctno) = 10SELECT * FROM ppeecnxhb WHERE OldPdctNo LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin  AND LEN(OldPdctNo) = 10 

2.將生產型號中含有小寫字母批次更新為大寫--只過濾硬板，FPC不包含在內

--將生產型號中含有小寫字母批次更新為大寫--只過濾硬板，FPC不包含在內update mktxhglb SET pdctno = UPPER(pdctno)WHERE pdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin AND LEN(pdctno) = 10update mktdelivery SET pdctno = UPPER(pdctno)WHERE pdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin AND LEN(pdctno) = 10update mkthtpsb SET pdctno = UPPER(pdctno)WHERE pdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin AND LEN(pdctno) = 10update ppeecnxhb SET Newpdctno = UPPER(Newpdctno)WHERE Newpdctno LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin AND LEN(Newpdctno) = 10update ppeecnxhb SET OldPdctNo = UPPER(OldPdctNo) WHERE OldPdctNo LIKE ‘%[a-z]%‘ COLLATE chinese_prc_bin AND LEN(OldPdctNo) = 10

 

PCB MS SQL SERVER 欄位含小寫字母更新為大寫字母