Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Unique ID filds

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-06 : 11:03:49
Tomas writes "Hi i am trying to port a web-application writen in access to sql server witch uses ids for recognising rows. In Access the bottomrow of the table has something like this "(AutoNumber)" but when i import into sql-server it does no recognice this. so when i forinstance try to add a record i get this error message "Cannot insert the value NULL into column 'cell_id', table 'web-db.dbo.cell_tab'; column does not allow nulls. INSERT fails." and if i allow instert NULL then i will just get NULL and no unique id´s as i want to have in the field cell_id.


Hoppe you can help me


/ Tomas Karlsson"
   

- Advertisement -