📄 示例6.sql

📁 SQL基础教程上的一些源码

💻 SQL

字号:

USE testTrigger
GO
INSERT BOOKS (BOOKid,BOOKName,BOOKNum)
VALUES(-1,'TEST BOOK',-1)
GO
SELECT * FROM BOOKS
GO

USE testTrigger
GO
DELETE BOOKS WHERE BOOKid =-1
GO
ALTER TABLE BOOKS
ADD CONSTRAINT chkBOOKidAndBOOKNum CHECK (BOOKid>=0 and BOOKNum>=0);
GO

USE testTrigger
GO
INSERT BOOKS (BOOKid,BOOKName,BOOKNum)
VALUES(-1,'TEST BOOK',-1)
GO
SELECT * FROM BOOKS
GO

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -