No announcements
Found 3236840 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 | 7819 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 | 46750 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 | 7149 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 | 9122 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 | 7352 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 | 6080 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 | 76753 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 | 2845 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 | 2921 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 | 4275 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 | 6737 Views | Created by pq.msdn - Wednesday, March 17, 2010 12:40 PM | Last reply by JasonRoth - Thursday, April 8, 2010 3:17 PM -
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 | 12775 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 -
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 | 7932 Views | Created by Laxmikant Deshpande - Saturday, September 1, 2012 6:26 AM | Last reply by SQLZealots - Monday, September 3, 2012 7:17 AM -
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 | 9540 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 | 7841 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 | 10524 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 -
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 | 6817 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
insert record into a table with identity column...
thanks.. but i am trying to insert artifically generated numbers into an indentity column..Answered | 3 Replies | 3852 Views | Created by SSAS_5000 - Thursday, July 2, 2009 8:48 PM | Last reply by Sudeep Raj - Friday, July 3, 2009 9:09 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 | 2807 Views | Created by vikas kumar pathak - Saturday, August 3, 2013 10:02 AM | Last reply by Visakh16 - Saturday, September 20, 2014 9:33 AM -
0 Votes
TURN off Identity insert OFF for all tables
I'm inserting data into a blank db that needs to allow values to be inserted into the identity columns.Answered | 4 Replies | 9187 Views | Created by C-Sharp Mamba - Tuesday, July 3, 2012 1:54 PM | Last reply by Satheesh Variath - Tuesday, July 3, 2012 3:57 PM - Items 1 to 20 of 3236840 Next ›
No announcements
