MS SQL数据库表关系 [英] Ms sql database table relation
本文介绍了MS SQL数据库表关系的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我需要一些基本的数据库帮助.我已经创建了2个这样的表.
hi all friends,
I need to some basic database help. I have create 2 table like this.
create table tblUser
(
loginid int NOT NULL PRIMARY KEY ,
fullname varchar(35)NOT NULL,
address varchar(50),
gender varchar(10),
nicnumber int NOT NULL,
username varchar(25)NOT NULL,
password varchar(25)NOT NULL,
vpassword varchar(25)NOT NULL
)
CREATE TABLE tblLogin
(
loginid int NOT NULL,
username varchar(50) NOT NULL,
password varchar(25) NOT NULL,
type varchar(15) NOT NULL,
CONSTRAINT pk_userlog FOREIGN KEY(loginid) REFERENCES tblUser(loginid)
)
如何使这些表同步.这意味着一旦我更新,删除或插入到一个表中,它也必须在另一个表中生效.
我不知道该如何使用这项技术.如果可以从其他Sp或视图中完成操作,或者执行其他任何操作,请您可以指导任何人,或者提供简单的说明.
在此先感谢.
ruzan
how can I make these tables synchronize. it mean once I update or delete or insert into one table it have to effect in other table too.
I don''t know the technology how to use this. f it''s can be done from other Sp or view or anything please can you guide anyone, or a simple expaining refence as well.
Thanks in Advance.
ruzan
推荐答案
亲爱的朋友,
为此,您应该在sql表中使用触发器以进行表
创建触发器tr1
在tblUser上进行删除,
如
从tblUser中删除,其中loginid(从已删除中选择*)
从tblLoginwhereloginid中删除(从已删除中选择*)
返回
对此进行分析并尝试,
问候,
Anilkumar.D
Dear Friend,
For this you should use triggers in sql for perticular table
create trigger tr1
on tblUser for delete,
as
delete from tblUser where loginid (select * from deleted)
delete from tblLoginwhere loginid (select * from deleted)
return
analize this and try,
Regards,
Anilkumar.D
这篇关于MS SQL数据库表关系的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文