MS SQL数据库表关系 [英] Ms sql database table relation

问题描述

大家好，

我需要一些基本的数据库帮助.我已经创建了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屋！