triggerdemo13.sql

T-SQL示例大全

/*
文件名称: TriggerDemo13.sql
*/
USE 北风贸易
GO

-- 先删除 MyTable 数据表所有的数据记录以避免混淆
DELETE MyTable
GO

INSERT MyTable (代码,姓名,薪资) VALUES ('A0001','洪志豪',80000)
INSERT MyTable (代码,姓名,薪资) VALUES ('A0002','章立民',30000)
INSERT MyTable (代码,姓名,薪资) VALUES ('A0003','周时恕',50000)
INSERT MyTable (代码,姓名,薪资) VALUES ('B0001','李小珠',20000)
INSERT MyTable (代码,姓名,薪资) VALUES ('B0002','陈一平',145000)
INSERT MyTable (代码,姓名,薪资) VALUES ('B0003','许洪年',25000)
INSERT MyTable (代码,姓名,薪资) VALUES ('C0001','王金超',20000)
INSERT MyTable (代码,姓名,薪资) VALUES ('D0001','游文隆',45000)
INSERT MyTable (代码,姓名,薪资) VALUES ('E0001','张顶升',25000)
GO

SELECT * FROM MyTable ORDER BY 代码
GO

UPDATE MyTable SET 薪资 = 15000 WHERE 姓名 = '陈一平'
UPDATE MyTable SET 代码 = 'A0004',薪资 = 210000 WHERE 姓名 = '许洪年'
GO

SELECT * FROM MyTable ORDER BY 代码
GO