Just Learned - DEFAULT or NULL are not allowed as explicit identity values.

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

DEFAULT or NULL are not allowed as explicit identity values.

Jun 15 2011 1:44AM by Fazal Vahora

When we try to insert some explicit data into an IDENTITY column the following error occurred.

Create Table test1
(
Id Int Identity(1,1),
Id2 int
)
Go

Set identity_insert test1 on
Insert test1 (Id,Id2) values(Null,1)
Set identity_insert test1 off

Error is: Msg 339, Level 16, State 1, Line 3 DEFAULT or NULL are not allowed as explicit identity values.

Read More.. [46 clicks]

Published under: SQL Server Tips · · · ·

Previous: SQL Server - TransactionLog impact detection using DMV
Next: Smart Date Ranges

Fazal Vahora

21 · 9% · 2806

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

1 Comments

Also refer this post http://beyondrelational.com/blogs/madhivanan/archive/2011/02/09/can-an-identity-column-be-nullable.aspx

commented on Jun 15 2011 3:43AM

Madhivanan

3 · 39% · 12472

Your Comment

Sign Up or Login to post a comment.

" DEFAULT or NULL are not allowed as explicit identity values." rated 5 out of 5 by 3 readers