摘要：
1usingSystem;2usingSystem.Text.RegularExpressions;34namespacebobomousecom.crm5{6/**////<summary>7///Regexlib的摘要说明。8///</summary>9publicclassRegexlib10{11publicRegexlib()12{13//14//TODO:在此处添加构造函数逻辑15//16}171819//搜索输入字符串并返回所有href=“”值20stringDumpHrefs(StringinputString)21{22Regexr;23Matchm; 阅读全文
摘要：
1 ROW_NUMBERSELECT ProductID, Name, Price, ROW_NUMBER() OVER(ORDER BY Price DESC) As PriceRankFROM ProductsProductIDNamePricePriceRank8Desk495.0000110Executive Chair295.000029Chair125.000035Mouse14.950046Mousepad9.9900511Scissors8.500064Stapler7.950073Binder1.95008...SELECT c.Name, o.DateOrde... 阅读全文
摘要：
表:T字段:id自动递增,field1数字,.....select*from(select*,(selectcount(*)fromTast2wheret2.field1=t1.field1andt2.id<=t1.id)asaaafromTast1)ast3whereaaa<=2取出数据中每个分类前5条selectID,title,D_Picture,addtime,newstypeid,jj,contentFROMnewsnswhereIDin(selecttop5IDfromnewswherenewstypeid=ns.newstypeidandisActive='1 阅读全文
