I have PostgreSQL 9 database that uses auto-incrementing integers as primary keys. I want to duplicate some of the rows in a table (based on some filter criteria), while changing one or two values, i.
Example: create table foo( id serial, txt text ); insert into foo(txt) values (\'a\'),(\'b\'),(\'c\') returning id;
I don\'t know how I can return all attributes with the RETURNING clause I want something like this: DECLARE
Is there an SQL Server equivalent to Oracle\'s RETURNING statement? I\'m wondering if开发者_StackOverflow中文版 the OUTPUT clause would help.Yes, the OUTPUT clause is exactly what you need.
花樽与花 (Live) 周笔畅 专辑：周笔畅2015香港红磡演唱会 语种： 粤语 发行时间：2015-08-23
加载中,请稍侯......