SQL Server 2005数据库中的DDL触发器描述
时间:2025-11-05 05:13:40 出处:应用开发阅读(143)

复制DROP DATABASE [DDLTRTEST] GO CREATE DATABASE DDLTRTEST GO USE [DDLTRTEST] GO IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE OBJECT_IDOBJECT_ID = OBJECT_ID(N[DBO].[MYTABLE]) AND TYPE IN (NU)) DROP TABLE [DBO].[MYTABLE] GO CREATE TABLE MYTABLE(ID INT,据库 NAME VARCHAR(100)) GO INSERT INTO MYTABLE SELECT 1,A INSERT INTO MYTABLE SELECT 2,B INSERT INTO MYTABLE SELECT 3,C INSERT INTO MYTABLE SELECT 4,D INSERT INTO MYTABLE SELECT 5,E INSERT INTO MYTABLE SELECT 6,F GO USE [DDLTrTest] GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[usp_querymytable]) AND type in (NP, NPC)) DROP PROCEDURE [dbo].[usp_querymytable] GO CREATE PROC USP_QUERYMYTABLE AS SELECT * FROM MYTABLE GO 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.
分享到:
温馨提示:以上内容和图片整理于网络,仅供参考,希望对您有帮助!如有侵权行为请联系删除!