Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

记一次SQL Server Insert触发器编写过程

WBOY
Release： 2016-06-07 17:37:45
Original
1156 people have browsed it

实现功能：新增特定类型的新闻时，自动追加特定的背景图片。 第一版(错误信息： 不能在 'inserted' 表和 'deleted' 表中使用 text、ntext 或 image 列 )，代码如下： (, ) ) drop trigger tgr_news_QA_insert tgr_news_QA_insert on news , ; id, , @newstyp

实现功能：新增特定类型的新闻时，，自动追加特定的背景图片。

第一版(错误信息：不能在 'inserted' 表和 'deleted' 表中使用 text、ntext 或 image 列)，代码如下：

(, ) ) drop trigger tgr_news_QA_insert tgr_news_QA_insert on news , ; id, , @newstype = newstype from inserted news id

Related labels：
insert server write trigger process
source：php.cn
Previous article： 表数据变更记录日志的经验分享(SqlServer) Next article： Sql之表的连接总结
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1361
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template