“sybase数据库恢复” 的评论 http://www.sybedit.com 又一个 WordPress 博客 Tue, 31 Aug 2010 13:12:13 +0800 http://wordpress.org/?v=2.8.1 hourly 1 andkylee 关于 How to delete duplicate rows? 的评论 http://www.sybedit.com/?p=97&cpage=1#comment-697 andkylee Tue, 31 Aug 2010 13:12:13 +0000 http://www.sybedit.com/?p=97#comment-697 多放一些介绍你的工具的文章上来，这个比较吸引点击率。 多放一些介绍你的工具的文章上来，这个比较吸引点击率。

]]> andkylee 关于 How to delete duplicate rows? 的评论 http://www.sybedit.com/?p=97&cpage=1#comment-696 andkylee Tue, 31 Aug 2010 13:11:11 +0000 http://www.sybedit.com/?p=97#comment-696 最近开始搞些小tips了。 最近开始搞些小tips了。

]]> 系统管理员 关于 How to delete duplicate rows? 的评论 http://www.sybedit.com/?p=97&cpage=1#comment-694 系统管理员 Tue, 31 Aug 2010 01:48:46 +0000 http://www.sybedit.com/?p=97#comment-694 The way is delete by "create a clustered index with a ignore_dup_row" You can try it. --------------------------------------------------------------------- create clustered index index_name on table_name(col1,col2,col3) with ignore_dup_row --------------------------------------------------------------------- The way is delete by “create a clustered index with a ignore_dup_row”
You can try it.
———————————————————————
create clustered index index_name on table_name(col1,col2,col3) with ignore_dup_row
———————————————————————

]]> 系统管理员 关于 How to find missing data? 的评论 http://www.sybedit.com/?p=96&cpage=1#comment-690 系统管理员 Mon, 30 Aug 2010 08:21:16 +0000 http://www.sybedit.com/?p=96#comment-690 SELECT curr.number, min(next.number) FROM number curr, number next WHERE curr.number < next.number GROUP BY curr.number HAVING (min(next.number) - curr.number) > 1 go number ----------- ----------- 3 5 SELECT curr.number, min(next.number) FROM
number curr, number next
WHERE curr.number < next.number
GROUP BY curr.number
HAVING (min(next.number) - curr.number) > 1
go
number
———– ———–
3 5

]]> Silva Marez 关于 LogDigger 的评论 http://www.sybedit.com/?p=74&cpage=1#comment-674 Silva Marez Tue, 24 Aug 2010 16:51:51 +0000 http://www.sybedit.com/?p=74#comment-674 information to my Company ;-) Please keep it up. I look for your Articles on my iphone rss feed every day. information to my Company ;-) Please keep it up. I look for your Articles on my iphone rss feed every day.

]]> 5UIT！ 关于 永不停止的BCP 的评论 http://www.sybedit.com/?p=88&cpage=1#comment-673 5UIT！ Tue, 24 Aug 2010 14:27:45 +0000 http://www.sybedit.com/?p=88#comment-673 小站弄的还挺不错 小站弄的还挺不错

]]> party supplies 关于 LogDigger 的评论 http://www.sybedit.com/?p=74&cpage=1#comment-658 party supplies Thu, 12 Aug 2010 20:00:39 +0000 http://www.sybedit.com/?p=74#comment-658 Fantastic blog! I truly love how it is easy on my eyes and the data are well written. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your rss feed which ought to do the trick! Have a nice day! Fantastic blog! I truly love how it is easy on my eyes and the data are well written. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your rss feed which ought to do the trick! Have a nice day!

]]> 黑社会电影 关于 bcp导数据进入死循环 的评论 http://www.sybedit.com/?p=82&cpage=1#comment-657 黑社会电影 Thu, 12 Aug 2010 17:53:01 +0000 http://www.sybedit.com/?p=82#comment-657 写的很不错。谢谢 写的很不错。谢谢

]]> andkylee 关于 powersybedit之数据误删恢复 的评论 http://www.sybedit.com/?p=11&cpage=1#comment-152 andkylee Sat, 13 Mar 2010 06:25:16 +0000 http://www.sybedit.com/?p=11#comment-152 通过扫描整个数据库的设备进行恢复，这种方法实现了吗？ 通过扫描整个数据库的设备进行恢复，这种方法实现了吗？

]]> andkylee 关于 8月3日软件更新 的评论 http://www.sybedit.com/?p=52&cpage=1#comment-137 andkylee Fri, 05 Mar 2010 15:44:52 +0000 http://www.sybedit.com/?p=52#comment-137 shakeone的回答很精彩啊。如果我要是早看到他的这个回复就省了不少功夫了。不过迄今他说的这些都已经通过自己操作验证了。 shakeone的回答很精彩啊。如果我要是早看到他的这个回复就省了不少功夫了。不过迄今他说的这些都已经通过自己操作验证了。

]]>