- 博客(6)
- 收藏
- 关注
RSS订阅转载 script：查看历史sql执行信息
'4.dba_hist_sqlstat' || '实例号:' || SQL.INSTANCE_NUMBER。FROM (SELECT '1.v$sql'||'实例号:'||GV$SQL.inst_id source,'在cursor cache中' end_time,
2023-03-06 22:09:12
140
原创 user without login sp_change_users_login
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-change-users-login-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7d129880-048c-4834-a72e-c31ead4897c
2021-11-20 09:46:28
906
原创 MSSQL deadlock
第一步，先创建两个表，并插入数据CREATE TABLE Lock1(C1 int default(0));CREATE TABLE Lock2(C1 int default(0));INSERT INTO Lock1 VALUES(1);INSERT INTO Lock2 VALUES(1);第二步：执行第一个sqlBegin Tran Update Lock2 Set C1=C1+1; WaitFor Delay '00:00:10'; SELECT * FROM ...
2021-10-11 11:40:09
324
原创 2021-04-20
CREATE TABLE user (id int(11) NOT NULL AUTO_INCREMENT,card varchar(32) DEFAULT NULL COMMENT '编号',name varchar(32) DEFAULT NULL COMMENT '姓名',equipment_id int(11) DEFAULT NULL COMMENT '设备id',area_id int(10) DEFAULT NULL COMMENT '区域ID',start_time dateti
2021-04-20 17:04:12
114
原创 2021-03-11
##t.vbsset ws=WScript.CreateObject("WScript.Shell")ws.Run "D:\test\test.bat",0--##test.bat@echo offwevtutil cl Security /bu:D:\test\b10310_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2%_%time:~9,2%.evtxexitwevtutil cl Applic.
2021-03-11 09:55:35
66
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人