摘要:
1.重复记录操作:http://www.cnblogs.com/caotang/archive/2011/01/18/1937932.html2.替换更新:update Produce set produce.Cell_ID=replace(Cell_ID,',',' ') where Produce.Cell_ID like'%,%'3.表操作复制表(只复制结构)select * into b from a where 1<>1拷贝表(复制数据)insert into b(a, b, c) select d,e,f from b 阅读全文