极客船长

摘要： update a set a.UserAgent = b.UserAgent from InfoVisitDetails a inner join InfoVisitDetails b on a.IP = b.IP where a.VisitUrl like 'https://%' and a.IP 阅读全文

摘要： SELECT * FROM (SELECT t.*, RANK() OVER (PARTITION BY t.a ORDER BY t.b DESC) AS drank FROM table1 t) a WHERE drank=1 阅读全文

摘要： public static bool CheckAgent(string userAgent) { bool flag = false; string[] keywords = { "Android", "iPhone", "iPod", "iPad", "Windows Phone", "MQQB 阅读全文

摘要： dynamic contact = new ExpandoObject(); contact.Name = "Patrick Hines"; contact.Phone = "206-555-0144"; contact.Address = new ExpandoObject(); contact. 阅读全文

摘要： select a.name as 表名, max(b.rows) as 记录条数 from sysobjects a ,sysindexes b where a.id=b.id and a.xtype='u' group by a.name order by max(b.rows) desc 阅读全文

摘要： SELECT TOP 100 t.hostname, t.loginame, percent_complete, [session_id] , der.[request_id] , [start_time] AS '开始时间' , der.[status] AS '状态' , [command] A 阅读全文

摘要： Regex.Replace(LoginMobile, @"(?im)(\d{3})(\d{4})(\d{4})", "$1****$3"); //13431230555变成134****0555 阅读全文

摘要： 1、转到下载页面2、按F12后点击小窗口左上角的手机图标3：刷新页面开始下载（win10.iso:链接） 阅读全文

摘要： select * from baiduacg_cookies c cross apply (select top 1 * from product where AccountId=c.AccountId order by CreateTime desc)t 阅读全文

摘要： List<Person> list = obj.list.ToObject<List<Person>>() 阅读全文