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
SQL Server: Cannot update identity column (Read 6061 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL Server: Cannot update identity column
02.04.08 at 22:06:49
 
SQL Server: Cannot update identity column
 
Question:
I am using SQL Server 2005 and the driver/Provider - MSDASQL.1, Version - 02.81.1117.0  
 
I am getting this error:
[Microsoft][ODBC SQL server driver][SQL server] Cannot update identity column 'DNUCLEUS_UID'
 
Tried to do a single row update. the row was fetched using a query, the new value was changed. while clicking the update button the error message was generated.
 
Answer:
The table you are using contains an identity column. This column cannot be updated. If you did not change the value of this column you may want to consider to use the multiple rows update feature. Just follow these steps:
 
1. build a select statement just returning those rows and columns you wish to update. It may look something like this:
select col1,col2,col3 from mytable where id=1234
2. Retrieve the results in Excel and make the changes.
3. Then run the multiple rows update feature of SQL*XL to apply the changes to the database.
 
Hope this helps!
Back to top
 
 

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