注册 登录
编程论坛 SQL Server论坛

如何调用触发器将数据库内容显示在c#窗体文本框中?

程诗亮 发布于 2010-12-27 10:16, 1430 次点击
ALTER TRIGGER [dbo].[trig_InsertInfo] on [dbo].[talk]
FOR insert
AS
if exists(select id from inserted where id in(select id from talk))
begin
update talk set talkabout=(select talkabout from inserted) where id=(select id from inserted)
end
else
begin
insert into talk(id,talkabout)
select id,talkabout from inserted
end
1 回复
#2
cnfarer2010-12-27 14:30
这是主动数据库研究的内容。真正的主动数据库还没有!
1