SQL Server 2008 R2 - 触发器 [英] SQL Server 2008 R2 - triggers

问题描述

如何在SQL Server 2008 R2中的触发器上添加扩展属性。

我想在触发器上添加MS_Description。

How to add the extended properties on Trigger in SQL Server 2008 R2.
I want to add "MS_Description" on a trigger.

推荐答案

使用以下查询将MS_Desciption添加到触发器：



EXEC sys.sp_addextendedproperty

@name = N''MS_Description' '，

@value = N''TRIGGER DESCRIPTION''，

@ level0type = N''SCHEMA''，@ level0name = dbo，

@ level1type = N''TABLE''，@ level1name = TABLENAME，

@ level2type = N''TRIGGER''，@ level2name = TRIGGERNAME;



GO

Use below query to add the MS_Desciption to a Trigger:

EXEC sys.sp_addextendedproperty
@name = N''MS_Description'',
@value = N''TRIGGER DESCRIPTION'',
@level0type = N''SCHEMA'', @level0name = dbo,
@level1type = N''TABLE'', @level1name = TABLENAME,
@level2type = N''TRIGGER'', @level2name = TRIGGERNAME;

GO

您好，



查看以下链接...



T -SQL Tuesday：Easy Extended Properties [ ^ ]

SQL Server 2008中扩展属性的乐趣 [ ^ ]

sp_dropextendedproperty（Transact-SQL） [ ^ ]

问候，

GVPrabu

Hi,

Check the following links...

T-SQL Tuesday: Easy Extended Properties[^]
Fun with Extended Properties in SQL Server 2008[^]
sp_dropextendedproperty (Transact-SQL)[^]
Regards,
GVPrabu

CREATE DATABASE EMPLOYEES
USE EMPLOYEES

CREATE TABLE SAL_INFO(GRADE CHAR(2),SAL NUMERIC(8,2))
SELECT * FROM SAL_INFO

INSERT INTO SAL_INFO VALUES('A',50000)
INSERT INTO SAL_INFO VALUES('B',40000)
INSERT INTO SAL_INFO VALUES('C',30000)
SELECT * FROM SAL_INFO

CREATE TABLE EMP(EMP_NO INT,EMP_NAME VARCHAR(50),DEPT_NO CHAR(5),GRADE CHAR(2),BSAL NUMERIC(8,2))
SELECT * FROM EMP

CREATE TRIGGER TR_EMP ON EMP
FOR INSERT,UPDATE
AS
DECLARE @SAL NUMERIC(8,2)
SELECT @SAL = SAL_INFO.SAL FROM SAL_INFO,INSERTED
WHERE INSERTED.GRADE = SAL_INFO.GRADE
UPDATE EMP SET BSAL = @SAL FROM EMP,INSERTED
WHERE EMP.EMP_NO =  INSERTED.EMP_NO

INSERT INTO EMP VALUES(1001,'SAJU','D101','A',NULL)
INSERT INTO EMP VALUES(1002,'MUJI','D102','B',NULL)
INSERT INTO EMP VALUES(1003,'NIYAS','D103','C',NULL)
SELECT * FROM EMP

这篇关于SQL Server 2008 R2 - 触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！