1)sql语句：WITH CTE_SID(BSID,SID,sql_handle)AS(SELECT blocking_session_id,session_id,sql_handle FROM sys.dm_exec_requests WHERE blocking_session_id<>0 UNION ALL SELECT A.blocking_session_id,A.session_id,A.sql_handle FROM ...
SELECT a.name,b.rows FROM sysobjects AS a INNER JOINsysindexes AS b ON a.id=b.idWHERE(a.type='u')AND(b.indid IN(0,1))ORDER BY b.rows DESC 本文转自hbyh 51CTO博客，原文链接：http://blog.51cto.com/norman20000/1025001，如需...
可以加一些可选关键字，如 with encryption 属性，使视图变为加密，不可以查看视图中的sql脚本信息，下文通过演示的方式讲述视图加密操作，如下:1/*创建加密视图*/2 create view vw_test-视图名vw_test 3 with encryption-加密视图 4 as 5 ...
