我有一个像这样的默认表
+--+----------+--------+------+
|Id|class_name|class_id|medals|
+--+----------+--------+------+
|1 |7IPA1 |7 |3 |
|2 |7IPA2 |7 |2 |
|3 |7IPA3 |7 |5 |
|4 |8IPA1 |8 |1 |
|5 |8IPA2 |8 |7 |
|6 |8IPA3 |8 |3 |
+--+----------+--------+------+
这将由执行
UPDATE MYTABLE
SET CLASS_ID = SUBSTRING(CLASS_NAME,1,4)
+--+----------+--------+------+
|Id|class_name|class_id|medals|
+--+----------+--------+------+
|1 |7IPA1 |7IPA |3 |
|2 |7IPA2 |7IPA |2 |
|3 |7IPA3 |7IPA |5 |
|4 |8IPA1 |8IPA |1 |
|5 |8IPA2 |8IPA |7 |
|6 |8IPA3 |8IPA |3 |
+--+----------+--------+------+
如何保存此查询?这样,当我插入新数据时,该查询将自动执行
我正在使用SQL Server Management Studio 2012
也许你可以像下面那样使用老虎
create trigger trigger_class_id on MYTABLE
After
insert
as
UPDATE
MYTABLE
SET
CLASS_ID = SUBSTRING(CLASS_NAME, 1, 4) WHERE ID=inserted.ID
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句