摘要:
-- Author: <Author,,Name>-- Create date: <Create Date,,>-- Description: <Description,,>-- CREATE PROCEDURE [dbo].[SP_JOB_NAME] AS BEGIN BEGIN TRAN -- 阅读全文
摘要:
说明:sqlcmd -S 数据库服务器IP -U 用户名 -P 密码 -i sql文件路径 示例:sqlcmd -S 192.168.0.1 -U sa -P password -i F:\batch.sql 阅读全文
摘要:
捕获过滤器 port 50893 显示过滤器 tcp.port == 20051 and http contains "barcode"http.request.uri contains "barcode" and http.request.method=="POST" http.response_ 阅读全文
摘要:
SET STATISTICS PROFILE ON SET STATISTICS IO ON SET STATISTICS TIME ON SQL语句 SET STATISTICS PROFILE OFF SET STATISTICS IO OFF SET STATISTICS TIME OFF 阅读全文
摘要:
进程 ps -ef 查看所有进程 ps -ef|grep ssh 过滤查看ssh进程 ps -ef|grep nginx 过滤查看nginx进程 ps -ef|grep keepalived 过滤查看keepalived进程 IP ip a 查看IP keepalived systemctl sta 阅读全文
摘要:
使用SQLServer函数(适用于SQL Server 2017 及更高版本) STRING_AGG 参考:https://docs.microsoft.com/zh-cn/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-ver 阅读全文
摘要:
内网走有线(网关:192.168.1.1),外网走无线(网关:192.168.43.37) 1.设置无线适配器跃点数为1(通过windows界面操作) 2.配置本地路由(通过界面操作) route delete 0.0.0.0 #全段设置 route -p add 192.0.0.0 mask 25 阅读全文
摘要:
SQL Server开启READ_COMMITTED_SNAPSHOT --查询数据库状态 select name,user_access,user_access_desc, snapshot_isolation_state,snapshot_isolation_state_desc, is_rea 阅读全文
摘要:
wsappx应用商店自动更新关闭 阅读全文