表級觸發器不支持ddl語句視圖觸發器存儲過程必要性, In this article, we will un-riddle the ways to make use of the data definition language trigger (DDL Trigger), in order to monitor the progressions made to the database programming objects, View, Procedure
1. 查看用戶表 select name from sys.tables select name from sys.objects where type='U' select name from sysobjects where xtype='U' 其中type或xtype值:U = 用戶表?S = 系統表?V = 視圖?FN = 標量函數?TF = 表
視圖是一種虛擬表,是實際表的一種映射,主要針對一些復雜查詢的一個封裝,實際表數據修改,視圖數據自動更改 CREATE OR REPLACE VIEW V_TONY
AS
SELECT A.EMPNO AS EMPNO,A.EMPNO AS EMPNO1,A.ENAME AS ENAME,A.JOB AS JOB,B.DNAME AS DNAME,B.LOC
加密測試的存儲過程 IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE TYPE='P' AND NAME='P_TEST')
DROP PROCEDURE P_TEST
GO
CREATE PROCEDURE P_TEST(@USERNAME VARCHAR(20),@MSG VARCHAR(20) OUTPUT)
WITH ENCRYPTION
AS
BEGINIF(SELECT COUNT