selectPProduceID,SUBSTRING(PProduceID,3,len(PProduceID))fromdbo.Carton_BG_PProduceInfo wherePProduceIDlike'2015%'; select*intoCarton_BG_PProduceInfo160113fromCarton_BG_PProduceInfo; updateCarton_BG_PProduceInfosetPProduceID=SUBSTRING(PProduceID,3,len(PProduceID)) wherePProduceIDlike'2015%'

USEHR --1.定义需要查找的关键字。在搜索中，使用模糊搜索：LIKE'%@key_find%' DECLARE@key_findNVARCHAR(MAX)='自动钉机';--假设是找字符串"123" --2.用游标Cursor_Table，遍历所有表 DECLARECursor_TableCURSORFOR SELECTnamefromsysobjectsWHERExtype='u'ANDname<>'dtproperties'; OPENCursor_Table; DECLARE@tableNameNVARCHAR(MAX); FETCHNEX

selectPProduceID,SUBSTRING(PProduceID,3,len(PProduceID))fromdbo.Carton_BG_PProduceInfo wherePProduceIDlike'2015%' select*intoCarton_BG_PProduceInfo160113fromCarton_BG_PProduceInfo updateCarton_BG_PProduceInfosetPProduceID=SUBSTRING(PProduceID,3,len(PProduceID)) wherePProduceIDlike'2015%'