You are here: home » autocount_accounting » sqlqueryforupdatetheipaddressofautocountimagefilename

SQL Query for update the ipaddress of AutoCount ImageFileName

update item set ImageFileName = '\\promultisvr' + substring(imagefilename,17,100) where substring(imagefilename,1,16)='\\192.168.100.88' and itemcode='33151-S5H-T01' OR update item set imagefilename=replace(imagefilename,'\\192.168.100.88','\\promultisvr') where itemcode='MN125323VT'

autocount_accounting/sqlqueryforupdatetheipaddressofautocountimagefilename.txt · Last modified: 2025/04/04 06:48
CC Attribution-Share Alike 4.0 International Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International