|
更改單位
張貼日期 2013/5/22 15:22:45
作者 lutuni
|
UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB004]='PC' WHERE [MB004]='組'
UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB004]='PC' WHERE [MB004]='台'
UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB004]='PC' WHERE [MB004]='張'
UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB004]='PC' WHERE [MB004]='支'
UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB004]='Kg' WHERE [MB004]='公斤'
UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB004]='Ltr' WHERE [MB004]='公升'
|
|