27,579
社区成员
发帖
与我相关
我的任务
分享
--SELECT 不行,其它可以:
--> 生成测试数据表: [t1]
IF OBJECT_ID('[t1]') IS NOT NULL
DROP TABLE t1
GO
CREATE TABLE t1 ([cno] [nvarchar](10),[cname] [nvarchar](10))
INSERT INTO t1
SELECT '001','abc' UNION ALL
SELECT '002','def'
--> 生成测试数据表: [t2]
IF OBJECT_ID('[t2]') IS NOT NULL
DROP TABLE t2
GO
CREATE TABLE t2 ([cno] [nvarchar](10),[sno] [nvarchar](10),[score] [int])
INSERT INTO t2
SELECT '001','001','79' UNION ALL
SELECT '001','002','89' UNION ALL
SELECT '001','003','88' UNION ALL
SELECT '002','001','98' UNION ALL
SELECT '002','002','99' UNION ALL
SELECT '002','003','100'
-->SQL查询如下:
IF OBJECT_ID('[tr_testtr]') IS NOT NULL
DROP trigger tr_testtr
GO
create trigger tr_testtr on c
for insert,update,delete
as
if object_id('[t2]') is not null
drop table t2
go
delete c
select * from t2
/*
消息 208,级别 16,状态 1,第 1 行
对象名 't2' 无效。
*/