use school go create trigger T2 on worker for delete as if (select number from deleted)='00001' begin print 'He is the CEO…
after-school 源代码
探索After-school电子技术资源库,涵盖235个精选项目与教程,专为电子工程师及爱好者设计。深入学习电路设计、嵌入式系统开发及物联网应用,提升您的技能至新高度。无论是初学者还是资深开发者,都能在这里找到适合自己的实践案例和技术文档,加速创新步伐。立即加入,开启您的电子技术…
Use SCHOOL Insert into Worker(Number,Name,Sex,Sage,Department) Values('00002','王勇','M',38,'科技部') select * from worker
USE SCHOOL delete from Course where cno='0002'; select * from SC;
USE SCHOOL SET XACT_ABORT ON BEGIN TRANSACTION T1 insert into stu_union values ('95009','李勇','M',25,'EE'); insert into stu_uni…
USE School Create Table Scholarship ( M_ID varchar(10),Stu_id char(10),R_money int ) insert into Scholarship values ('000…
USE School Alter Table Scholarship add Constraint FK_Scholarship Foreign key(STU_ID) references STUDENTS(sid)
USE SCHOOL GO SET STATISTICS TIME ON GO CREATE clustered INDEX IX_sid ON CHOICES(SID) GO
USE SCHOOL GO SET STATISTICS TIME ON GO SET SHOWPLAN_ALL ON GO select score from STUDENTS,CHOICES where STUDENTS.grade = 200…
USE SCHOOL GO CREATE TABLE TEST2 ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL DEFAULT(NEWID()) PRIMARY KEY NONCLUSTERED, NAME VAR…
USE School GO SET STATISTICS TIME ON GO UPDATE CHOICES set score = score-1 GO