No announcements
Found 3237870 threads
-
0 VotesCannot insert explicit value for identity column in table '#Temp when IDENTITY_INSERT is set to OFF
If IDENTITY_INSERT is OFF, you can't explicity insert into an identity column.Answered | 3 Replies | 7566 Views | Created by John Basedow - Tuesday, November 17, 2009 7:57 PM | Last reply by John Basedow - Tuesday, November 17, 2009 8:24 PM
-
3 Votes
Cannot insert explicit value for identity column in table 'Business' when IDENTITY_INSERT is set to OFF.
[Business] (id,name) values (4,'SSSSSSSSSSSSSSSSSS') Go Here is the reproduced error message: Msg 544, Level 16, ...Answered | 6 Replies | 46268 Views | Created by Tony Long - Friday, July 29, 2011 3:20 AM | Last reply by Tony Long - Friday, July 29, 2011 3:57 PM -
2 Votes
Error-{"Cannot insert explicit value for identity column in table 'tblSubjectMaster' when IDENTITY_INSERT is set to OFF."}
Thank for help, there is table sujectmaster with column subjectid,subjectname,subjectar i want to insert data subject name in that table how will ...Answered | 3 Replies | 7039 Views | Created by Dhanashri13 - Monday, August 13, 2012 9:49 AM | Last reply by Dhanashri13 - Monday, August 13, 2012 11:02 AM -
0 Votes
An explicit value for the identity column in table 'productsales' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Answered | 18 Replies | 8876 Views | Created by S.Jitendra - Thursday, February 6, 2014 5:35 PM | Last reply by sqlsaga - Sunday, February 9, 2014 5:10 AM -
0 Votes
An explicit value for the identity column in table 'dbo.Tool' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Hi Am trying to do dynamic insert without specifying any columns , passing table name dynamically at run time.Answered | 7 Replies | 7106 Views | Created by Sandhya Kacham - Thursday, May 10, 2012 7:11 AM | Last reply by Satheesh Variath - Thursday, May 10, 2012 9:16 AM -
1 Votes
Cannot insert explicit value for identity column - sometimes
Sure enough, the ID column in s_Milestones wasn't set to Auto-Generated Value = true.Answered | 4 Replies | 5953 Views | Created by William_616 - Tuesday, February 8, 2011 7:01 PM | Last reply by David Peng - Monday, February 14, 2011 9:46 AM -
2 Votes
i am getting error as An explicit value for the identity column in table 'product' can only be specified when a column list is used and IDENTITY_INSERT is ON.
You have to insert without the identity column and for the identity column you have to change this value just once.Answered | 7 Replies | 65554 Views | Created by S.Jitendra - Wednesday, February 5, 2014 5:00 PM | Last reply by uvillegas - Thursday, January 14, 2016 6:53 PM -
1 Votes
Problem when Identity Insert is Set Off
If the statement did not affect any tables with identity columns, @@IDENTITY returns NULL.Answered | 9 Replies | 2664 Views | Created by DIEGOCTN - Thursday, January 10, 2013 11:18 AM | Last reply by scott_morris-ga - Thursday, January 10, 2013 3:34 PM -
0 Votes
Execution error 3155 Explicit value must be specified for identity column when IDENTITY_INSERT is on
create Table IDentitytest(col1 int identity(1,1),col2 varchar(50)) Insert into IDentitytest(col2) Select 'SQL' -- ...Answered | 9 Replies | 2499 Views | Created by Claude Larocque - Friday, November 15, 2013 11:01 AM | Last reply by Mike Lewis (SQLTuna) - Monday, November 18, 2013 9:15 AM -
0 Votes
IDENTITY_INSERT is set to OFF
SET IDENTITY_INSERT products ON GO -- Attempt to insert an explicit ID value ...Answered | 2 Replies | 4112 Views | Created by Philosophiae - Thursday, March 14, 2013 5:56 PM | Last reply by Kalman Toth - Friday, March 15, 2013 2:41 PM -
0 Votes
Cannot insert explicit value for identity column in table - code-first with EF generated DB
That Id field is a primary key and is also an identity column.Answered | 1 Replies | 6632 Views | Created by pq.msdn - Wednesday, March 17, 2010 12:40 PM | Last reply by JasonRoth - Thursday, April 8, 2010 3:17 PM -
0 Votes
'Set Identity_Insert table_Name OFF' not setting 'Identity_Specification' to 'No' in SQL Server
statement1 = Set IDENTITY_INSERT PatientTrans ON statement2 = insert into ...Answered | 15 Replies | 7535 Views | Created by Laxmikant Deshpande - Saturday, September 1, 2012 6:26 AM | Last reply by SQLZealots - Monday, September 3, 2012 7:17 AM -
3 Votes
Inserting rows into table with Identity column
Create table sqldemp(id int identity(1,1),data char(10)) Insert into sqldemp values('a'),('b'),('c'),('d'),('e'),('f') select * from ...Answered | 3 Replies | 12488 Views | Created by srinivasa rao yenninti - Monday, December 17, 2012 11:45 AM | Last reply by Manish_Kaushik - Monday, December 17, 2012 3:34 PM -
1 Votes
An explicit value for the identity column in table can only be specified when a column
You may get the desired output using below query; CREATE TABLE #Table (ID INT ...Answered | 2 Replies | 9380 Views | Created by Gaurav 17 - Friday, March 2, 2012 6:51 AM | Last reply by Hasham Niaz - Friday, March 2, 2012 8:06 AM -
0 Votes
Data insert from temp table to a table with identity insert
Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table ...Answered | 14 Replies | 7500 Views | Created by oleolehoohoo - Friday, September 20, 2013 7:27 PM | Last reply by Stefan Hoffmann - Monday, September 23, 2013 8:11 AM -
0 Votes
Table with Identity column issue
When you set a table's IDENTITY_INSERT mode to ON, you must provide the IDENTITY column value (explains the first error you ...Answered | 3 Replies | 10235 Views | Created by Hardy - Monday, November 15, 2010 3:15 AM | Last reply by João Paulo Figueira - Monday, November 15, 2010 3:38 PM -
3 Votes
IDENTITY_INSERT ON
Msg 8101, Level 16, State 1, Line 2 An explicit value for the identity column in table 'TempCatalogProducts' can only be specified ...Answered | 9 Replies | 8551 Views | Created by KevinBurton - Friday, January 11, 2013 4:13 PM | Last reply by Carsoner - Wednesday, December 25, 2013 7:55 AM -
2 Votes
Identity insert on.
We got solution, as this identity is session level, so if identity insert is on for other table in same session it will not allow you to make ...Answered | 5 Replies | 2559 Views | Created by vikas kumar pathak - Saturday, August 3, 2013 10:02 AM | Last reply by Visakh16 - Saturday, September 20, 2014 9:33 AM -
1 Votes
IDENTITY_INSERT is set to OFF
In addition to what Naomi described , sometimes there are cases when we need to INSERT_IDENTITY value explicitly , scenario might be Identity value might be ...Answered | 9 Replies | 6514 Views | Created by ryguy72 - Tuesday, October 18, 2011 7:34 PM | Last reply by Hasham Niaz - Tuesday, October 18, 2011 9:31 PM -
0 Votes
SET IDENTITY_INSERT <tablename> ON required
An explicit value for the identity column in table 'dbo.TableName' can only be specified when a column list is ...Answered | 9 Replies | 8896 Views | Created by Efioj - Wednesday, August 22, 2012 6:01 PM | Last reply by DotNetMonster - Tuesday, August 28, 2012 12:13 PM - Items 1 to 20 of 3237870 Next ›
No announcements
