鳖鳖耶夫-CSDN博客

原创事务脚本

USE [test]GOBEGIN tran v_1_0_2_1 --指定版本号declare @tran_error intset @tran_error=0begin tryIF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[test]’) AND type in (N’U’))DROP TABLE [dbo].[test]SET ANSI_NULLS ONSET QUOTED_IDENT

2021-04-28 16:49:49 139

原创 git删除tag

删除远程tag：git push origin :refs/tags/v_8_0_1_12

2020-10-16 10:12:26 143

原创 SQLSERVER查询某个外键被引用的表

exec sp_helpconstraint ‘Users’;

2020-08-27 13:10:56 831

原创 windows logstash配置

1.多路径配置2.解决log显示成多行问题3.解决中文乱码问题Sample Logstash configuration for creating a simpleBeats -> Logstash -> Elasticsearch pipeline.input {file {path=>“C:/website/portal/Log/.log"start_position => beginningcodec=>multiline {pattern =>

2020-06-30 14:39:43 482 1

原创 kafka常用命令

查看topic列表：.\bin\windows\kafka-topics --zookeeper localhost:2181 --list查看topic详情：.\bin\windows\kafka-topics --zookeeper localhost:2181 --describe --topic test创建topic.\bin\windows\kafka-topics --create --zookeeper localhost:2181 --replication-factor 1 -

2020-06-28 15:53:04 3185

转载 kafka windows安装

https://blog.csdn.net/u011671747/article/details/105204691/

2020-06-28 15:26:34 132

转载 elastic 添加用户密码

https://blog.csdn.net/SimpleSimpleSimples/article/details/105020926

2020-06-10 17:16:22 821

原创 docker常用命令

docker run -d -p 5000:80 freestoneljd/projectapi:latestcurl http://127.0.0.1:5000/weatherforecastdocker stop [contaniter id]docker restart [contaniter id]docker ps -adocker images进入容器docker exec -it [es] /bin/bashdocker rm [container id]docker rm

2020-06-08 13:41:22 138

原创 Sqlserver查询库中包含了某字段的表

select NAME from [库名].[dbo].sysobjects where id in (select id from [库名].[dbo].syscolumns Where name=‘字段名’)

2020-06-04 16:27:13 1093

转载创建solr core

https://blog.csdn.net/DamonRush/article/details/78875139

2020-05-29 15:15:02 143

原创 Sqlserver插入自增id

set identity_insert [dbo].[MU_RIGHT] onINSERT INTO [dbo].[MU_RIGHT]([UID],[RightName],[RightDescription],[GroupName])VALUES(621,‘Help_Doc_Delete’,‘Help_Doc_Delete’,‘Option’)GOset identity_insert [dbo].[MU_RIGHT] off

2020-05-26 14:47:56 1342

原创 .NET Windows Server的安装和卸载

.NET Windows Server的安装和卸载安装将C:\Windows\Microsoft.NET\Framework64\v4.0.30319下的InstallUtil.exe拷贝到windowsserver debug/realase目录下admin权限执行cmd ：installutil AU.Monah.PMRS.WindowsServer.exe卸载删除注册表HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PNP

2020-05-21 14:38:31 1291

u010336156的博客