tags:

views:

20

answers:

0
Q: 

Why inserting 0 (zero) to Sql Server Auto Increment Field when inserting Fisrt Time

I go a big problem that when i am inserting First record to a table, that has one auto increment field. This field is accepting 0 (zero) when first time insert.. What is the problem. its making my program error

related questions

How to force MySQL to take 0 as a valid auto-increment value
auto_increment no longer increments
Auto increment a value in Django with respect to the previous one
How to prevent primary serial primary key from being updated with number not in sequence?
SQL-How to Insert Row Without Auto incrementing a ID Column?
MySQL table incrementing by 10 for some reason
Make one ID with auto_increment depending on another ID - possible?
Get Auto Increment value with MySQL query
Is it possible to have an AUTO_INCREMENT column that permits duplicates?
MySQL current_insert_id()? (Not last_insert_id())
Can one rely on the auto-incrementing primary key in your database?
SQL Server: Retrieve auto-incremented ID inside a stored procedure?
Use current auto_increment value as basis for another field in the same INSERT query - is this possible in MySQL?
Scoped/composite surrogate keys in MySQL
auto_increment by group
Can you use auto-increment in MySql with out it being the primary Key
Auto Increment In rails
Reset auto-incrementing column
AutoIncrement fields on databases without autoincrement field
Can you access the auto increment value in MySQL within one statement?
Linq to sql error with identitiy increment field
JavaDB: Is it possible to change auto-increment offset on existing table?
Autoincrement in Oracle
Alternative to "PDO::lastInsertId" / "mysql_insert_id"
make an ID in a mysql table auto_increment (after the fact)