?? viewcompiletest.sql
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -