.net技术
leonwan
这个作者很懒,什么都没留下…
展开
-
解决数据内有'的sql语句
<br />SELECT OrderId, TableName, replace(PrimaryKeyColumn,'''','''''') as PrimaryKeyColumn, ColumnState,cast(IsUpdating as varchar) as IsUpdating, OperateTime, ValueColumn, SystemTypeID FROM SubCompFtpDataDairy where OperateTime>=dateadd(hh,-24,getdate())原创 2010-05-31 16:15:00 · 313 阅读 · 0 评论 -
删除重复记录
<br />SQL>delete cz where (c1,c10,c20) in (select c1,c10,<br />c20 from cz group by c1,c10,c20 having count(*)>1) and rowid not in<br />(select min(rowid) from cz group by c1,c10,c20 having count(*)>1);<br />SQL>delete cz where rowid not in<br />(select mi原创 2010-05-31 16:16:00 · 288 阅读 · 0 评论