极客船长

摘要： DECLARE @TAB TABLE ( UserID INT, UserName NVARCHAR(50) ) INSERT INTO @TAB ( UserID, UserName ) VALUES (0,N'西门炊鳕'), (1,N'夜雇乘'), (2,N'令狐冲'), (3,N'士兵甲'), 阅读全文

摘要： function exportCSV(title, jsonData, name) { // 要导出的json数据 let str = ``; for (let i of title) { str += i + "," } str += "\n" // 增加\t为了不让表格显示科学计数法或者其他格式 阅读全文

摘要： 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:链接） 阅读全文