| | | |

2009年6月16日

几个常用SQL2000语句

摘要：排名语句select *,(select count(1) +1 from tPlanApply where applyquantity> a.applyquantity ) as 名次 from tPlanApply a order by 名次替换语句 SQL code update tbset 字段=replace(字段,替换后字符串,替换前字符串) 阅读全文

posted @ 2009-06-16 08:43 Delphi学习之路阅读(93) 评论(0) 推荐(0)

几个常用SQL2000语句

摘要：排名语句select *,(select count(1) +1 from tPlanApply where applyquantity> a.applyquantity ) as 名次 from tPlanApply a order by 名次替换语句SQL code update tbset 字段=replace(字段,替换后字符串,替换前字符串) 阅读全文

posted @ 2009-06-16 08:43 Delphi学习之路阅读(415) 评论(0) 推荐(0)