how to use? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

how to use?

Author

Topic

beliveinmyshelf
Starting Member

15 Posts

Posted - 2007-06-15 : 23:45:35

222222222222222222.
i'm create database by t-sql :

create database linh
ON(
name='linh_db',
filename='C:\linh_db.mdf',
size=5MB,
maxsize=10MB,
filegrowth=1MB
)
log on
(
name='linh_db_log',
filename='C:\linh_db_log.ldf',
size=3MB,
maxsize=6MB,
filegrowth=1MB
)

okie?

and i create table in this database :

use linh
create table login
(
Login_id int identity(1,1),
Login_name varchar(30) constraint Login_id primary key,
Login_password varchar(20),
)
create table userinfor
(
Login_name varchar(30) foreign key(Login_name) REFERENCES login(Login_name) on update cascade,
Login_email varchar(50) not null,
Login_adress varchar(100) not null,
)

i have login.Login_name,it is primary key in login table and userinfor.Login_name is foreign key in userinfor table.i create relationship for them by "on update cascade". but when i insert data to login table then userinfor is empty.
i think, i don't know to use "update cascade". please help me

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-16 : 00:35:24

Read about on update cascade in sql server help file to know how it works

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources