适用SQL语句汇总
1.重复记录操作:http://www.cnblogs.com/caotang/archive/2011/01/18/1937932.html
2.替换更新:update Produce set produce.Cell_ID=replace(Cell_ID,',',' ') where Produce.Cell_ID like'%,%'
| 复制表(只复制结构) | select * into b from a where 1<>1 |
| 拷贝表(复制数据) | insert into b(a, b, c) select d,e,f from b |
做了就有可能!

浙公网安备 33010602011771号