viewcompiletest.sql

《SQLServer2000宝典》—包括本书中的所有代码

USe Northwind

drop view ViewTest

Create alter View ViewTest as 
Select * from Employees

--DBCC FREEPROCCACHE

Select * from dbo.viewtest

Select * from viewtest


SELECT cacheobjtype, usecounts as Count,
    cast(C.sql as Char(50)) as StoredProcedure , ObjType   
  FROM Master.dbo.syscacheobjects C
  JOIN  Master.dbo.sysdatabases D
    ON C.dbid = C.dbid
  WHERE D.Name = DB_Name() 
  ORDER BY StoredProcedure