No announcements
Found 1430169 threads
-
0 VotesPrimary key error
In Table A, i have two fields together as Primary Key.Answered | 8 Replies | 4713 Views | Created by NSG12 - Tuesday, March 30, 2010 3:54 PM | Last reply by Kalman Toth - Sunday, April 4, 2010 12:30 PM
-
3 Votes
Violation of primary key constraint error
Hi, I ensure that there is no other primary key .But still the same error comes.Once I make Identity specificatio OFF and ON ,And then insert,It ...Answered | 4 Replies | 2201 Views | Created by manojkumar09 - Monday, September 23, 2013 7:33 AM | Last reply by pituach - Thursday, November 7, 2013 8:34 AM -
1 Votes
Primary Key
Hi, You can not create primary key on empno as the values of empno have duplicates(empno 10 and empno 30) in a primary key column.Answered | 7 Replies | 2701 Views | Created by pnreddy - Tuesday, February 14, 2012 12:17 PM | Last reply by jaisean - Tuesday, February 14, 2012 1:12 PM -
3 Votes
PRIMARY KEY
*/ At any rate, it is a bad choice for PRIMARY KEY.Answered | 6 Replies | 1601 Views | Created by I4QR1A - Thursday, November 27, 2014 8:12 PM | Last reply by DileepReddyAchhala - Friday, November 28, 2014 11:21 AM -
0 Votes
primary key violation errors
If you want to test this anyway, you could run the following two updates: UPDATE test SET b=b+1 UPDATE test SET b=b-1 In ...Answered | 15 Replies | 4358 Views | Created by neophytenik - Tuesday, July 13, 2010 7:58 PM | Last reply by Gert-Jan Strik - Wednesday, July 14, 2010 5:45 PM -
0 Votes
Primary key
As Kalman wrote, Primary Key is a default Unique Key.Answered | 10 Replies | 3510 Views | Created by swethakrishna - Thursday, August 1, 2013 10:48 AM | Last reply by --CELKO-- - Thursday, August 1, 2013 4:56 PM -
0 Votes
Primary key
Create table table with CREATE TABLE, define the primary key.Answered | 12 Replies | 1005 Views | Created by simonxy - Wednesday, February 24, 2016 5:33 PM | Last reply by Sam Zha - Thursday, February 25, 2016 3:48 AM -
1 Votes
Primary keys
PRIMARY KEY is never NULL.Answered | 4 Replies | 1160 Views | Created by FenixRising - Monday, March 31, 2014 7:35 PM | Last reply by Kalman Toth - Tuesday, April 1, 2014 8:12 PM -
0 Votes
got error on sql inserting - Violation of PRIMARY KEY
A table can have only one PRIMARY KEY constraint, and a column that participates in the PRIMARY KEY constraint cannot accept null values.Answered | 4 Replies | 4647 Views | Created by E_gold - Sunday, March 10, 2013 7:58 AM | Last reply by Jackson_1990 - Sunday, March 10, 2013 10:05 AM -
0 Votes
Primary Key and Foreign Key
For example, suppose you have a Products table with primary key ProductID and an Orders table with primary key OrderID and each line item on the ...Answered | 4 Replies | 1224 Views | Created by Ronald Rex - Sunday, September 9, 2018 12:21 AM | Last reply by Ronald Rex - Sunday, September 9, 2018 7:02 PM -
0 Votes
Primary keys
Do you mean by "relationships in a DB-schema" a) relation, thus two tables having the primary key over the same set of attributes ...Answered | 4 Replies | 525 Views | Created by loinike - Friday, July 15, 2016 7:42 AM | Last reply by Stefan Hoffmann - Friday, July 15, 2016 8:49 AM -
1 Votes
Primary key and Foreign Key
See this illustration create table t ( id int identity(1,1) not null primary key, val varchar(100) ) create table t2 ( id int not ...Answered | 4 Replies | 1533 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
1 Votes
about insert and primary key
Since we have no DDL, we have no idea what the primary key is.Answered | 10 Replies | 2006 Views | Created by bestrongself - Wednesday, March 12, 2014 4:03 AM | Last reply by --CELKO-- - Wednesday, March 12, 2014 2:44 PM -
1 Votes
Two Primary key for table???
tHE BOLD line shows that it has two primary key The bold line shows that you have a primary key composed by two columns.Answered | 2 Replies | 4669 Views | Created by Incredible15 - Sunday, September 12, 2010 4:44 PM | Last reply by Hunchback - Sunday, September 12, 2010 5:06 PM -
0 Votes
with the transaction primary key violation error
Error handling in SQL Server is a very messy story.Answered | 11 Replies | 5864 Views | Created by Tharindu Dhaneenja - Wednesday, October 6, 2010 11:07 AM | Last reply by Tharindu Dhaneenja - Thursday, October 7, 2010 4:22 AM -
1 Votes
Primary Key Violation
IDENTITY and Primary Key are not the same.Answered | 3 Replies | 5121 Views | Created by DBA_KevyKev - Saturday, November 14, 2009 10:33 PM | Last reply by DogTog - Sunday, November 15, 2009 1:19 AM -
2 Votes
Primary Key Already Exists
When during the linked table creation process a primary key could be determined, then Jet/DAO creates the primary key on the linked table itself.Answered | 3 Replies | 1810 Views | Created by IndigoMontoya - Monday, April 6, 2015 4:01 PM | Last reply by Stefan Hoffmann - Monday, April 6, 2015 9:03 PM -
3 Votes
Composite Primary key and Foreign key
I would say FIPS is a primary key although I haven't checked.Answered | 18 Replies | 61040 Views | Created by mahima - Friday, February 8, 2008 3:51 PM | Last reply by Kalman Toth - Sunday, April 10, 2011 8:52 PM -
0 Votes
primary key not found
The error message is pretty clear.Answered | 2 Replies | 3157 Views | Created by richfp - Wednesday, December 19, 2012 7:47 PM | Last reply by MasaSam - Friday, December 21, 2012 6:44 AM -
2 Votes
Difference Primary Key & Unique key?
4)A table can have only one primary key.Answered | 3 Replies | 6283 Views | Created by GurunGuns - Saturday, June 26, 2010 10:02 AM | Last reply by Mohammad Nizamuddin - Saturday, June 26, 2010 11:35 AM - Items 1 to 20 of 1430169 Next ›
No announcements
