06 2019 档案
BCP 数据导出
摘要:EXEC master..xp_cmdshell 'BCP test.dbo.name out d:\t_002.txt -c -t -T' EXEC master..xp_cmdshell 'BCP "select name from test.dbo.name" queryout d:\t_00 阅读全文
posted @ 2019-06-26 15:43 wxm3177 阅读(170) 评论(0) 推荐(0)
sql 死锁查看
摘要:--每秒死锁数量 SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE 'Number of Deadlocksc%'; --查询当前阻塞 WITH CTE_SID ( BSID, SID, sql_handle ) 阅读全文
posted @ 2019-06-10 15:11 wxm3177 阅读(353) 评论(0) 推荐(0)