代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584123
sql 2.2.14.sql
use school
create table teach_course(
course_id char(4),cname varchar(30),teacher_id char(6)
constraint PK_teach_course primary key(course_id)
constraint FK_teach_course foreign key(te
www.eeworm.com/read/446181/7584124
sql 2.2.8.sql
USE school
alter table choices drop [FK_CHOICES_STUDENTS];
alter table choices add
CONSTRAINT [FK_CHOICES_STUDENTS] FOREIGN KEY
(
[sid]
) REFERENCES [dbo].[STUDENTS] (
[sid]
)on dele
www.eeworm.com/read/446181/7584125
sql 2.2.2.sql
USE SCHOOL
CREATE TABLE SC(
sno CHAR(5) REFERENCES Stu_Union (sno) on delete cascade,
cno CHAR(4) REFERENCES Course(cno) on delete cascade,
grade INT,
CONSTRAINT PK_SC PRIMARY KEY (sno,cno)
);
www.eeworm.com/read/446181/7584126
sql 2.3.5.sql
Use SCHOOL
Insert into Worker(Number,Name,Sex,Sage,Department) Values('00002','王勇','M',38,'科技部')
select * from worker
www.eeworm.com/read/446181/7584127
sql 2.2.1.sql
USE SCHOOL
insert Stu_Union values ( '10001','李勇','0',24,'EE')
select * from Stu_Union;
create table Course (
cno char(4) NOT NULL UNIQUE,
cname varchar(50) NOT NULL,
cpoints int,
const
www.eeworm.com/read/446181/7584128
sql 2.2.5.sql
USE SCHOOL
delete from Course where cno='0002';
select * from SC;
www.eeworm.com/read/446181/7584129
sql 2.2.7.sql
USE school
create table ICBC_Card(
bank_id char(20),
stu_card_id char (14) references stu_card(card_id) on delete cascade,
restored_money decimal (10,2),
constraint PK
www.eeworm.com/read/446181/7584130
sql 2.1.4.sql
USE SCHOOL
SET XACT_ABORT ON
BEGIN TRANSACTION T1
insert into stu_union values ('95009','李勇','M',25,'EE');
insert into stu_union values ('95003','王浩','0',25,'EE');
insert into stu_union values ('
www.eeworm.com/read/446181/7584132
sql 2.1.7.sql
USE School
Create Table Scholarship
(
M_ID varchar(10),Stu_id char(10),R_money int
)
insert into Scholarship values ('0001','700000',5000)
insert into Scholarship values ('0001','800000',800