第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

已解決430363個問題，去搜搜看，總會有你想問的

數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼盡量簡單？

首頁猿問數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼...

數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼盡量簡單？

SQL Server

瀟瀟雨雨 2018-12-06 14:40:28

create table student(sno char(9) primary key,sname varchar(20),ssex char(2),sage smallint,sdept varchar(20)); create table course(cno char(4) primary key,cname varchar(40),cpno char(4),ccredit smallint,foreign key(cpno) references course(cno)); ? create table sc(sno char(9),cno char(4),grade smallint,primary key(sno,cno),foreign key(sno) references student(sno), foreign key(cno) references course(cno)); ? insert into student values('200215121','李勇','男',20,'CS');insert into student values('200215122','劉晨','女',19,'CS');insert into student values('200215123','王敏','女',18,'MA');insert into student values('200215124','張立','男',19,'IS'); insert into COURSE values('0002','數(shù)學',NULL,2);insert into COURSE values('0006','數(shù)據(jù)處理',NULL,2);insert into COURSE values('0007','PASCAL語言','0006',4);insert into COURSE values('0005','數(shù)據(jù)結構','0007',4);insert into COURSE values('0001','數(shù)據(jù)庫','0005',4);insert into COURSE values('0003','信息系統(tǒng)','0001',4);insert into COURSE values('0004','操作系統(tǒng)','0006',3); insert into sc values('200215121','0001',92);insert into sc values('200215121','0002',85);insert into sc values('200215121','0003',88);insert into sc values('200215122','0002',90);insert into sc values('200215122','0003',80);insert into sc values('200215123','0001',93);insert into sc values('200215124','0001',90); ? 然后我要刪除6號課程記錄會報錯怎么刪除求大神指導

查看完整描述

8 回答

炎炎設計

TA貢獻1808條經(jīng)驗獲得超4個贊

---- 1、刪除

USE testdb2
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[student]') AND type IN (N'U')) DROP TABLE [student];

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[course]') AND type IN (N'U')) DROP TABLE [course];

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[sc]') AND type IN (N'U')) DROP TABLE [sc];



create table student(sno char(9) primary key,sname varchar(20),ssex char(2),sage smallint,sdept varchar(20));

create table course(cno char(4) primary key,cname varchar(40),cpno char(4),ccredit smallint);

create table sc(sno char(9),cno char(4),grade smallint,
primary key(sno,cno),foreign key(sno) references student(sno),
foreign key(cno) references course(cno) on delete cascade );


 

insert into student values('200215121','李勇','男',20,'CS');
insert into student values('200215122','劉晨','女',19,'CS');
insert into student values('200215123','王敏','女',18,'MA');
insert into student values('200215124','張立','男',19,'IS');

insert into COURSE values('0002','數(shù)學',NULL,2);
insert into COURSE values('0006','數(shù)據(jù)處理',NULL,2);
insert into COURSE values('0007','PASCAL語言','0006',4);
insert into COURSE values('0005','數(shù)據(jù)結構','0007',4);
insert into COURSE values('0001','數(shù)據(jù)庫','0005',4);
insert into COURSE values('0003','信息系統(tǒng)','0001',4);
insert into COURSE values('0004','操作系統(tǒng)','0006',3);

insert into sc values('200215121','0001',92);
insert into sc values('200215121','0002',85);
insert into sc values('200215121','0003',88);
insert into sc values('200215122','0002',90);
insert into sc values('200215122','0003',80);
insert into sc values('200215123','0001',93);
insert into sc values('200215124','0006',90);


DELETE FROM course WHERE cno = '0006' ;

select * from course c 
select * from student s 
select * from sc

反對回復 2019-01-07

侃侃爾雅

TA貢獻1801條經(jīng)驗獲得超16個贊

你要先刪外建表的記錄，如sc 、student表對應的外建記錄

反對回復 2019-01-07

HUWWW

TA貢獻1874條經(jīng)驗獲得超12個贊

觸發(fā)器試試

反對回復 2019-01-07

寶慕林4294392

TA貢獻2021條經(jīng)驗獲得超8個贊

你在外鍵加上?on delete cascade

反對回復 2019-01-07

冉冉說

TA貢獻1877條經(jīng)驗獲得超1個贊

具體在哪里，說清楚一點謝謝，本人剛學

反對回復 2019-01-07

慕標5832272

TA貢獻1966條經(jīng)驗獲得超4個贊

@米老鬼:?

反對回復 2019-01-07

森林海

TA貢獻2011條經(jīng)驗獲得超2個贊

@劉宏璽:?我用的不是這個軟件，是Microsoft sql好像只能寫代碼吧，能不能說一下怎么通過寫代碼實現(xiàn)級聯(lián)刪除還有寫在什么地方

反對回復 2019-01-07

慕容3067478

TA貢獻1773條經(jīng)驗獲得超3個贊

@米老鬼:?…………

反對回復 2019-01-07

8 回答
0 關注
716 瀏覽

關注

添加回答

舉報

0/150

提交

取消

第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

熱搜

最近搜索清空

數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼盡量簡單？

數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼盡量簡單？

8 回答

添加回答

數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼盡量簡單？

數(shù)據(jù)庫怎么通過寫代碼級聯(lián)刪除，代碼盡量簡單？