chk123的专栏

<br />1.数据库表信息查询视图<br />--查找所有用户表的信息<br />IF object_id(N'dbo.TableInfo', 'V') IS NOT NULL<br /> DROP VIEW dbo.TableInfo<br />GO<br />CREATE VIEW TableInfo AS<br /><br />SELECT S.name AS [SCHEMA],O.name AS TABLENAME,C.name AS COLUMNNAME,T.name AS DATATYPE,C

  SELECT * FROM SYS.SYSPROCESSES WHERE SPID&gt;50     SELECT c.query_plan, b.text, a.* FROM SYS.DM_EXEC_requests as a cross apply (select * from sys.dm_exec_sql_text(a.sql_handle)) as b cross a...