宇泰資訊

當產品編為前二碼xx時更改庫別MAxxx

張貼日期 2012/5/5 17:18:41
作者 lutuni
1.
UPDATE [Leader].[dbo].[INVMB]
SET [MB017]='MA101'
WHERE SUBSTRING([MB001],1,2)='01'
2.
UPDATE [Leader].[dbo].[INVMB]
SET [MB017]='MA102'
WHERE SUBSTRING([MB001],1,2)='02'
3.
UPDATE [Leader].[dbo].[INVMB]
SET [MB017]='MA201'
WHERE SUBSTRING([MB001],1,2)='03'
4.
UPDATE [FLUXTEK_1].[dbo].[INVMB]
SET [MB017]='MA401'
WHERE SUBSTRING([MB001],1,2)='31'
5.
UPDATE [FLUXTEK_1].[dbo].[INVMB]
SET [MB017]='MA301'
WHERE SUBSTRING([MB001],1,2) BETWEEN '04' AND '30'
6.
UPDATE [FLUXTEK_1].[dbo].[INVMB]
SET [MB017]='MA301'
WHERE SUBSTRING([MB001],1,2) BETWEEN '32' AND '44'




這篇日誌來自 宇泰資訊
http://123.204.89.156/etype

這篇日誌所在的網址(URL)
http://123.204.89.156/etype/modules/weblog/details.php?blog_id=67