![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
语句
云中月-
这个作者很懒,什么都没留下…
展开
-
sql server语句
1.sqlserver查询锁语句 : IF EXISTS(SELECT * FROM master.sys.sysprocesses WHERE spid IN (SELECT blocked FROM master.sys.sysprocesses)) –确定有进程被其他的进程锁住 SELECT DISTINCT ‘进程ID’ = STR(a.spid, 4) ,‘进程ID状态’ = CONVE...翻译 2019-12-30 17:02:23 · 180 阅读 · 0 评论 -
ms-sql全库索引重建脚本
use database_name go DECLARE @name varchar(100) DECLARE authors_cursor CURSOR FOR Select [name] from sysobjects where xtype='u' order by id OPEN authors_cursor FETCH NEXT FROM authors_cursor INTO ...原创 2018-09-12 08:56:17 · 235 阅读 · 0 评论