Use SCHOOL Insert into Worker(Number,Name,Sex,Sage,Department) Values('00001','李勇','M',14,'科技部') Select * From Worker
after-school 源代码
探索After-school电子技术资源库,涵盖235个精选项目与教程,专为电子工程师及爱好者设计。深入学习电路设计、嵌入式系统开发及物联网应用,提升您的技能至新高度。无论是初学者还是资深开发者,都能在这里找到适合自己的实践案例和技术文档,加速创新步伐。立即加入,开启您的电子技术…
Use SCHOOL Create Table Worker( Number char(5), Name char(8) constraint U1 unique, Sex char(1), Sage int constraint U2 check…
Use SCHOOL Insert into Worker(Number,Name,Sex,Sage,Department) Values('00002','王勇','M',38,'科技部') Select * From Worker
USE SCHOOL delete from Stu_Union where sno='10001'; select * from SC;
USE SCHOOL SET XACT_ABORT ON BEGIN TRANSACTION T2 insert into stu_union values ('95007','李明','M',25,'EE'); select * From stu_…
use school create table listen_course ( teacher_id char(6),tname varchar(20),course_id char(4) constraint PK_listen_cou…
use school go create trigger T3 on Worker for update as if update(number) begin print 'Everynumber cannot be changed!' Rol…
use school go create trigger T1 on worker for insert , update as if (select sage from inserted)
use school go create rule rule_sex as @value in ('F','M') go exec sp_bindrule rule_sex ,'worker.[sex]';
USE School Alter Table Scholarship add Constraint PK_Scholarship Primary key(M_ID)