Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Inserting into table with IDENTITY field (Read 1716 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Inserting into table with IDENTITY field
14.09.09 at 10:45:01
 
Insert into table with IDENTITY field
 
Quote:
Can i insert new rows in a table that already has an IDENTITY field? i.e. can I provide non-key data in a new insertion?

 
Yes you can. Omit it from the data you send as the values are automatically created by the database.  
 
See also:
Problems inserting into tables with autonumber / sequence / identity columns  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1149148853
Back to top
 
« Last Edit: 14.09.09 at 10:46:14 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1