数据库知识点及技巧
关注
分享
扫一扫
sunnyboycao
这个作者很懒，什么都没留下…
展开
-
SQL SERVER2005的row_number()实现分页
SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY [id] ASC) AS RowNum, * FROM table) AS T WHERE RowNum BETWEEN X AND Y转载 2009-04-20 15:15:00 · 271 阅读 · 0 评论 -
替换字段中的字符串
update openpfdesc set description=replace(description, 需替换的字串, ‘替换成的字串);原创 2010-03-24 09:26:00 · 389 阅读 · 0 评论