sql添加数据后返回受影响行数据
Jun 07, 2016 pm 06:03 PMInserted 表用于存储 INSERT 和 UPDATE 语句所影响的行的副本。在一个插入或更新事务处理中，新建行被同时添加到 inserted 表和触发器表中
Inserted 表中的行是触发器表中新行的副本。语法
返回所有列
INSERT INTO [tableName] ([columnName1],[columnNameN],...) OUTPUT inserted.* VALUES ('value1','value2',...)
返回指定列
INSERT INTO [tableName] ([columnName1],[columnNameN],...) OUTPUT inserted.[columnName] VALUES ('value1','value2',...)
获取数据就跟平常SELECT语句一样的 用vo或者dataset装
Hot Article
Hot tools Tags
Hot Article
Hot Article Tags
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Reduce the use of MySQL memory in Docker
Mar 04, 2025 pm 03:52 PM
Reduce the use of MySQL memory in Docker
How do you alter a table in MySQL using the ALTER TABLE statement?
Mar 19, 2025 pm 03:51 PM
How do you alter a table in MySQL using the ALTER TABLE statement?
How to solve the problem of mysql cannot open shared library
Mar 04, 2025 pm 04:01 PM
How to solve the problem of mysql cannot open shared library
Run MySQl in Linux (with/without podman container with phpmyadmin)
Mar 04, 2025 pm 03:54 PM
Run MySQl in Linux (with/without podman container with phpmyadmin)
What is SQLite? Comprehensive overview
Mar 04, 2025 pm 03:55 PM
What is SQLite? Comprehensive overview
Running multiple MySQL versions on MacOS: A step-by-step guide
Mar 04, 2025 pm 03:49 PM
Running multiple MySQL versions on MacOS: A step-by-step guide
How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?
Mar 18, 2025 pm 12:00 PM
How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?
How do I configure SSL/TLS encryption for MySQL connections?
Mar 18, 2025 pm 12:01 PM
How do I configure SSL/TLS encryption for MySQL connections?
