假設資料表名稱為 A update A set DCODE=DCODE+'C' where CODE like 'M00[1234]' --如果你只是想找 M0...
假設資料表名稱為 A update A set DCODE=DCODE+'C' where CODE like 'M00[1234]' --如果你只是想找 M0...
table name : a update a set DCODE=DCODE+'C' where CODE>='M001' and CODE<='...
table name : a update a set DCODE=DCODE+'C' where CODE>='M001' and CODE<='...
試試 http://www.techbang.com/posts/4851-free-installation-of-windows-7-production-...