failed to create ID
来源:学生学帮网 编辑:学帮网 时间:2024/06/05 12:31:22
failed to create ID
1> CREATE TRIGGER AfterUpdateTest
2> ON test_trigger_table
3> FOR UPDATE
4> AS
5> DECLARE
6> @OldName VARCHAR(10),
7> @NewName VARCHAR(10);
8> BEGIN
9> PRINT('AFTER UPDATE');
10> SELECT @NewName = name FROM inserted;
11> SELECT @OldName = name FROM deleted;
12> PRINT('Old Name = ' + @OldName);
13> PRINT('New Name = ' + @NewName);
14> END;
15> go
1>
2> UPDATE test_trigger_table SET name = 'XYZ' WHERE id = 1;
3> go
AFTER UPDATE
Old Name = ABC
(1 行受影响)
New Name = XYZ
上面的例子的 简单的 输出 发生 更新的信息.
如果 检查更新的内容不能含有某字符串
使用 字符串函数 CHARINDEX
如果指定字符串 有的话, 那么 ROLLBACK 掉, 然后看情况,是不是要抛出异常.
如果对您有帮助,请记得采纳为满意答案,谢谢!祝您生活愉快!
vaela
failed to create ID
failed to create IDispatch是什么意思
failed to create temporary是什么意思
奇迹世界failed to create application是什么意思
FAILED TO CREATE TEMPORARY FILE 什么原因
failed to create a secure downloader component failed to create a secure downloader component
开机出现failed to create tray icon这个怎么办啊?
failed to create file.please check your proivilege是什么意思?
device create failed是什么意思
Device create failed
create process failed
Diectroy Create Failed
英文是create physxmangager failed!
create skill module failed翻译
玩天龙出现错误Expr:Failed to create Direct3D9 Device:Invalid callC++ ExceptionExpr:Failed to create Direct3D9 Device:Invalid call哈哈 6楼就是我说的
DownloadTask?start:3:java.io.IOException:+Failed+to+create+file什么意思
eclipse启动时弹出Failed to create the Java Virtual Machine 是怎么回事?同题.
Eclipse运行时提示failed to create the java virtual machine 如何解决