22,209
社区成员
发帖
与我相关
我的任务
分享请教一个触发器的问题
有两个表a，b
定义如下
CREATE TABLE [a] (
[a_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[a_content] [image] NOT NULL ,
CONSTRAINT [PK_a] PRIMARY KEY CLUSTERED
(
[a_id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [b] (
[b_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[a_id] [int] NOT NULL ,
[b_content] [image] NULL ,
CONSTRAINT [FK_b_a] FOREIGN KEY
(
[a_id]
) REFERENCES [a] (
[a_id]
)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
现在要在表b上建立触发器，当插入时根据外键a_id在表a中选取a_content作为b_content的默认值插入
这个有办法吗？
定义如下
CREATE TABLE [a] (
[a_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[a_content] [image] NOT NULL ,
CONSTRAINT [PK_a] PRIMARY KEY CLUSTERED
(
[a_id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [b] (
[b_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[a_id] [int] NOT NULL ,
[b_content] [image] NULL ,
CONSTRAINT [FK_b_a] FOREIGN KEY
(
[a_id]
) REFERENCES [a] (
[a_id]
)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
现在要在表b上建立触发器，当插入时根据外键a_id在表a中选取a_content作为b_content的默认值插入
这个有办法吗？
...全文
请发表友善的回复…
发表回复
Tian987 2006-06-27
- 打赏
- 举报
谢谢，成功了
losedxyz 2006-06-27
- 打赏
- 举报
InsteadOfInsert
zlp321002 2006-06-27
- 打赏
- 举报
Instead Of 可以的...
Tian987 2006-06-27
- 打赏
- 举报
知道这个，好象超过8k自动截断了
paoluo 2006-06-27
- 打赏
- 举报
try
Create Trigger InsteadOfInsert On B
Instead Of Insert
AS
Insert B (a_id,b_content) Select C.a_id,A.a_content From Inserted C Inner Join A On A.a_id=C.a_id
GO
Create Trigger InsteadOfInsert On B
Instead Of Insert
AS
Insert B (a_id,b_content) Select C.a_id,A.a_content From Inserted C Inner Join A On A.a_id=C.a_id
GO
