随笔分类 -  随笔

摘要:Start Notepad in administrator mode, and open the file (substituting Community for Professional or Enterprise depending on your version): C:\Program F 阅读全文
posted @ 2023-06-08 22:13 Thinking.N 编辑
摘要:添加表说明:EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1n 阅读全文
posted @ 2022-12-14 09:20 Thinking.N 编辑
摘要:过滤器处理异常 public class GlobalExceptionFilter : IExceptionFilter { private ILogger _logger; public GlobalExceptionFilter(ILogger logger) { _logger = logg 阅读全文
posted @ 2022-11-22 22:02 Thinking.N 编辑
摘要:1、asp.net core IIS部署运行环境修改目录下的web.config <aspNetCore processPath="dotnet" arguments=".\WebApi.dll" stdoutLogEnabled="false" stdoutLogFile=".\logs\stdo 阅读全文
posted @ 2022-11-07 11:57 Thinking.N 编辑
摘要:处理方法,修改注册表 Add the following values to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion Add: DWORD ForceLog set value to 1 DWORD LogFailures set value to 阅读全文
posted @ 2019-10-24 08:37 Thinking.N 编辑
摘要:有时候数据库在占用时,想做一些操作,无法操作。可以尝试将数据库切换为单用户模式来操作。操作完之后再切换回多用户模式。 命令如下: alter database 数据库名 set Single_user 单用户 alter database 数据库名 set multi_user 多用户 或者 sp_ 阅读全文
posted @ 2019-10-21 11:09 Thinking.N 编辑
摘要:解除redis保护模式: 1、修改redis服务器的配置文件 vi redis.conf 注释以下绑定的主机地址 \ bind 127.0.0.1 daemonize "yes" protected mode "no" daemonize:yes:redis采用的是单进程多线程的模式。当redis. 阅读全文
posted @ 2019-08-19 13:43 Thinking.N 编辑
摘要:int[] arrInt; arrInt = new int[]{1,2,3,45,6,8,9}; var r1 = arrInt.All(m => m > 10);// 所有元素都满足条件,false var r2 = arrInt.Any(m => m > 10);// 有任一元素满足条件,true ... 阅读全文
posted @ 2019-08-13 10:06 Thinking.N 编辑
摘要:1、安装rabbitmq需要提前安装erlang,相关下载地址:http://www.erlang.org/downloads,需要注意:默认安装的RabbitMQ 监听端口是5672 启动和关闭 /sbin/service rabbitmq-server stop #关闭 /sbin/servic 阅读全文
posted @ 2019-07-30 16:21 Thinking.N 编辑
摘要:--为字段添加注释 --Eg. execute sp_addextendedproperty 'MS_Description','字段备注信息','user','dbo','table','字段所属的表名','column','添加注释的字段名'; execute sp_addextendedpro 阅读全文
posted @ 2019-07-04 10:10 Thinking.N 编辑
摘要:1、NSSM.exe https://nssm.cc/ 2、Topshelf 引用地址:https://www.cnblogs.com/guogangj/p/10093102.html#4136330 阅读全文
posted @ 2019-01-09 15:29 Thinking.N 编辑
摘要:--每秒死锁数量 SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE 'Number of Deadlocksc%'; --查询当前阻塞 WITH CTE_SID ( BSID, SID, sql_handle ) AS ( SELECT blocking_ses... 阅读全文
posted @ 2019-01-09 14:26 Thinking.N 编辑
摘要:--查询死锁 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' --杀死死锁进程 kill 3... 阅读全文
posted @ 2018-12-12 09:12 Thinking.N 编辑
摘要:/// /// 用流的方式下载文件 /// /// 文件路径及文件名 public static void FileDownLoad(string filepath_name) { System.IO.Stream iStream = null; //以10K为单... 阅读全文
posted @ 2018-11-07 16:42 Thinking.N 编辑
摘要:string lameEXE = @"D:\lame3.100\lame.exe"; string lameArgs = "-b 128"; string wavFile = @"d:\d.mp3"; string mp3File = @"d:\ff.mp3"; Process process =... 阅读全文
posted @ 2018-07-31 10:45 Thinking.N 编辑
摘要:引用:https://www.cnblogs.com/dansediao/p/6605141.html 阅读全文
posted @ 2018-06-27 16:39 Thinking.N 编辑
摘要:SELECT FK.NAME,FK.OBJECT_ID,OBJECT_NAME(FK.PARENT_OBJECT_ID) AS REFERENCETABLENAMEFROM SYS.FOREIGN_KEYS AS FKJOIN SYS.OBJECTS AS O ON FK.REFERENCED_OB 阅读全文
posted @ 2017-11-09 19:04 Thinking.N 编辑
摘要:using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Collections.Specialized; namespace TechnetSamples { class Program { static void Mai... 阅读全文
posted @ 2016-10-17 15:07 Thinking.N 编辑
摘要:EXEC sp_rename 'TableName.[ColumnName]','ColumnNew','COLUMN' 阅读全文
posted @ 2015-11-24 09:59 Thinking.N 编辑

点击右上角即可分享
微信分享提示