SQL Server Profiler检视查询窗口执行过程
1,通过SELECT HOST_NAME(),HOST_ID ()可获取到本机计算机名称(HostName)、ClientProcessID,在SQL Serv…
SqlServer 函数Declare通过传变量查询超慢解决办法
参考: 1,Declare传参查询速度慢,直接放入参数执行sql却快,求大牛给原因 2,OPTION(RECOMPILE)提高带参数执行SQL语句的索引效率 …
MS SqlServer恢复变成(单个用户)故障恢复
执行以下sql:替换数据库名称
1 2 3 4 5 6 7 8 9 10 |
USE master; GO DECLARE @SQL VARCHAR(MAX); SET @SQL='' SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID) FROM master..sysprocesses WHERE dbid=DB_ID('数据库名'); EXEC(@SQL); ALTER DATABASE 数据库名 SET MULTI_USER; |
html页面image src Base64转换为图并更新为url_C#
以下方法用在web请求方法中:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
void ReplaceContentImagerBase65Src() { Regex regImg = new Regex(@"<img src=(.*?)>", RegexOptions.IgnoreCase); string base64SourceValue = string.Empty, base64Value = string.Empty, fileName = string.Empty; // 搜索匹配的字符串 MatchCollection matches = regImg.Matches(Content); int i = 0; string[] imgList = new string[matches.Count]; // 取得匹配项列表 foreach (Match match in matches) { imgList[i++] = match.Value; base64SourceValue = match.Groups[1].Value.Substring(1, match.Groups[1].Value.Length - 2); if (!base64SourceValue.StartsWith("data:")) { continue; }; fileName = DateTime.Now.ToString("yyMMddHHmmssfff") + ".jpg";//可改善:根据Base64设置后缀名 imageSavePath = path + fileName; base64Value = base64SourceValue.Substring(base64SourceValue.IndexOf(",") + 1).Replace("\"", ""); Base64ToImage(base64Value, imageSavePath); Content = Content.Replace(base64SourceValue, @"http://blog.abc.com/img/" + fileName); } } |
c# – 在System.Drawing.Image.Save的GDI中发生一个通用错误
下面方法不能返回Image类型,否则会遇到标题的错误。因为【从Stream加载图像时,必须在图像的整个生命周期内保持流打开】,转换后的Image用到的流是str…
生成36进制流水号_C#
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
class Program { static void Main(string[] args) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("Decimal\tSerialLength\tHexadecimal\r\n"); long val = 1, maxnum = 46655;//1~ZZZ for (long i = 1; i <= maxnum; i++) { stringBuilder.Append( $"{i}\t3\t{ConvertTo36(i).PadLeft(3,'0')}\r\n"); Console.WriteLine(i); } System.IO.File.WriteAllText("./NumPools.text", stringBuilder.ToString()); } /// <summary> /// 10進制轉36進制 /// </summary> /// <param name="i">10進制值</param> /// <returns>36進制值</returns> public static string ConvertTo36(long i) { string s = ""; long j = 0; while (i >= 36) { j = i % 36; if (j < 10) s += j.ToString(); else s += Convert.ToChar(j + 87); i = i / 36; } if (i < 10) s += i.ToString(); else s += Convert.ToChar(i + 87); Char[] c = s.ToCharArray(); Array.Reverse(c); return Convert.ToString(new string(c)).ToUpper(); } } |