摘要: select T.*,P.ProductName from (select V.CompanyID,C.CompanyName,V.ProductCode from VehicleInsuranceAgentConfiguration V inner join Company C on V.CompanyID = C.CompanyID where V.IsDelete=0 and V.Ho... 阅读全文
posted @ 2016-07-18 16:27 会弹猫的吉他 阅读(153) 评论(0) 推荐(0) 编辑
摘要: 1: SELECT TOP 1 P.* FROM [ProxyServer] P JOIN (SELECT RAND()*100 AS Nid) T ON P.[Id]>T.Nid WHERE P.Cookie'' and P.CompanyID=1069 and P.ProductCode='TPCX'2: SELECT TOP 1 * FROM [ProxyServer] WHE... 阅读全文
posted @ 2016-07-18 16:23 会弹猫的吉他 阅读(257) 评论(0) 推荐(0) 编辑