Question

sql server里如何获得被触发器触发的表名？

Answer 1

创建表dbo.triggerTest
CREATE TABLE dbo.triggerTest ( rowId INT IDENTITY PRIMARY KEY, someData VARCHAR(50) DEFAULT NEWID() )
GO

---创建触发器
CREATE TRIGGER dbo.itrg_triggerTest ON dbo.triggerTest
FOR INSERT
AS

--查询该触发器触发的表
SELECT @@PROCID, OBJECT_NAME( @@PROCID )

SELECT OBJECT_SCHEMA_NAME( parent_id ) + '.' + OBJECT_NAME( parent_id ) tableName FROM sys.triggers WHERE object_id = @@PROCID
GO

INSERT INTO dbo.triggerTest DEFAULT VALUES
GO