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