Code: Detail

Especializações:Asp.net, Ajax, C#, Visual Basic.net, Wcf, XML FrameWork .net 1.1, 2.0 e 4.0, OO, Design Patterns Arquitetura SOA, DDD, MVP e MVVM Html, Css, JavaScript Sql Server 2000, 2005 e 2008 Oracle 8i e 9i Asp3, Visual Basic 6 e COM+

DB2 - (Portuguese)

Executar Insert e Consultar Identity

Este script Executa um comando Insert e obtem o valor do campo identity em um UNICO comando.

Last update: 09/10/2015
DB2       
 
N/A
N/A
N/A
N/A
 

select Campo_Identity_TABELA_A
from final table (
                  INSERT INTO TABELA_A(CAMPO2, CAMPO3, CAMPO4)
                  SELECT C1, C2, C3 FROM AMLBO.TABELA_B
                 )

Source:
 
Users who have marked this routine as a favorite
 
 
 
The site ti4fun is not responsible for the content on sites for which you have external links

Articles, routines, tips, forums, blogs or any other content posted on ti4fun site is not tested and not validated, so you should test and validate any information collected on the ti4fun site before applying it to final use environment, such as example, production. the TI4FUN site is not responsible for quality or for any damages, direct, indirect or consequential, from use of any content posted by the authors in the site.

All content published on the ti4fun site is the responsibility of the author and do not necessarily express the views of the site ti4fun and its employees.