what is identity insert on?

Question

1.50/5 (2 votes)

See more:

When iam executing this query am getting error....
insert into Tbl_Replace_Doc
select 50349+ROW_NUMBER() over(order by sh.code) ,
sd.C_Code,sd.C_Name,1,sh.grad,sd.C_Qualification,sd.C_Add_1,sd.C_Add_2,sd.C_Add_3,sd.C_Add_4,
sd.C_Pin,sd.C_Phone,sd.C_Fax,sd.C_Category,sd.C_Area_Code,sd.C_Subarea_Code,sd.D_DOB,
sd.D_DOW,sd.C_Email_ID,sd.C_FsCode,GETDATE(),0,'',null,0,GETDATE(),null,null,
sd.c_region_code,cd.c_div_code,sd.C_Doc_Class,null,null,sd.n_mcino,sd.C_FName,sd.C_LName
from sht sh
join Tbl_Doc_Stock_Chem_Add_Mst sd on sd.C_Code=sh.code
join Tbl_Cust_Div cd on cd.c_cust_code=sd.C_Code

error i have mentioned in below

Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'Tbl_Replace_Doc' can only be specified when a column list is used and IDENTITY_INSERT is ON

please give solution for this am waiting

Posted 10-May-15 21:12pm

Member 11337367

Add a Solution

Comments

Thanks7872 11-May-15 3:26am

You have set some column to identity so you should not insert values in that column. Search google for what is IDENTITY_INSERT ON.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 11039257 · Answer 1 · 2015-05-11T01:16:00

If you Declare column with Identity.You don't need to Insert value for that column.value will b automatically inserted based on values inserted on other columns

If u try u inserted Value to that identity Column ,u get that error as u encountered.

If u need to insert value explicitly u need to SET IDENTITY_INSERT TABLENAME ON
and u can start inserting values to that column.