No announcements
Found 370008 threads
-
0 VotesUnique key
yes, managerid is primary key Reviewer table.Answered | 4 Replies | 2212 Views | Created by chrissclee - Friday, July 6, 2012 6:52 PM | Last reply by --CELKO-- - Friday, July 6, 2012 10:13 PM
-
2 Votes
Difference Primary Key & Unique key?
5)Primary key is a combination of NOT NULL and Unique values.Answered | 3 Replies | 6274 Views | Created by GurunGuns - Saturday, June 26, 2010 10:02 AM | Last reply by Mohammad Nizamuddin - Saturday, June 26, 2010 11:35 AM -
1 Votes
Datatype Issue Unique Key
You’ll notice that same column has unique key and the primary key….Answered | 11 Replies | 6635 Views | Created by VATiger - Sunday, March 11, 2012 1:52 PM | Last reply by VATiger - Tuesday, March 20, 2012 7:54 PM -
0 Votes
Need Help on This [ Unique Key]
Hi, why Particular column can't accept multiple Null, which is bound with unique key ?Answered | 7 Replies | 2313 Views | Created by AshishSingh_DWH - Tuesday, July 17, 2012 4:59 AM | Last reply by Anand Ar - Tuesday, July 17, 2012 11:00 AM -
5 Votes
Can a unique key be a Foreign key
Yes Tiya, If Foreign key is uinque key then it can contain only a single null value.Answered | 4 Replies | 3558 Views | Created by Tiya01 - Thursday, January 5, 2012 9:17 AM | Last reply by Manish_Kaushik - Thursday, January 5, 2012 12:25 PM -
5 Votes
Unique and PRIMAY Key
A table may have only one primary key and the columns must not allow NULL but may have many unique constraints and unique indexes with nullable columns.Answered | 7 Replies | 821 Views | Created by ranjith87 - Monday, January 25, 2016 9:02 AM | Last reply by Dan Guzman - Monday, January 25, 2016 1:33 PM -
1 Votes
Unique Key
In the end you will most likely need a "Person" table with a unique id there and hopefully you can replicate that key out to the other databases.Answered | 4 Replies | 4655 Views | Created by ozsql - Friday, October 23, 2009 5:32 AM | Last reply by Marc Miles - Saturday, October 24, 2009 7:34 AM -
0 Votes
Create Unique Key Problem
It means you need to create two separate unique constraints, e.g.Answered | 6 Replies | 3853 Views | Created by First Programer - Thursday, October 27, 2011 3:38 AM | Last reply by First Programer - Thursday, October 27, 2011 4:36 AM -
3 Votes
SQL Server – Primary Key and a Unique Key
Unique [means different] Key: If you have a Unique Key: It allows only different ...Answered | 4 Replies | 3750 Views | Created by katty.jonh - Thursday, July 26, 2012 3:10 AM | Last reply by Kent Waldrop - Thursday, July 26, 2012 11:50 AM -
0 Votes
Problem in creating Unique Key on Columns.
You can also define more than one UNIQUE key or UNIQUE index on a table.Answered | 7 Replies | 3392 Views | Created by Incredible15 - Tuesday, April 20, 2010 2:21 PM | Last reply by Kalman Toth - Sunday, April 25, 2010 5:47 AM -
0 Votes
unique product key
please help me what is the unique product key?Answered | 1 Replies | 1522 Views | Created by 54214273481730643700650614 - Saturday, April 26, 2014 3:37 AM | Last reply by Dave Patrick - Saturday, April 26, 2014 1:55 PM -
0 Votes
Unique Key Column
Hi HuaMin , Thanks for reply i forgot to mention something 3 columns are there in 1 of them primary key is enabled suppose P_ID .Answered | 5 Replies | 939 Views | Created by Priya Bange - Thursday, March 14, 2013 3:47 AM | Last reply by Piotr Palka - Thursday, March 14, 2013 4:25 AM -
0 Votes
Violation of UNIQUE KEY constraint
From what little you posted, it looks like you are using a GUID for uniqueness inside a schema.Answered | 9 Replies | 1580 Views | Created by Rickaty - Wednesday, August 31, 2016 9:21 PM | Last reply by Naomi N - Thursday, September 1, 2016 9:54 AM -
2 Votes
2 Attribute together as unique key
Yes, you can create a composite primary key, unique constraint or unique index.Answered | 1 Replies | 1151 Views | Created by wapt49 - Tuesday, February 12, 2013 1:17 PM | Last reply by Dan Guzman - Tuesday, February 12, 2013 1:22 PM -
0 Votes
EF Inheritance and Unique Key issues
If the unique key column is at that side, EF4 does not support it either.Answered | 2 Replies | 3707 Views | Created by DWD - Wednesday, May 5, 2010 9:56 AM | Last reply by Michael Sun [MSFT] - Monday, May 10, 2010 1:46 AM -
5 Votes
What 's difference between Unique key and unique index
UNIQUE KEY is part of the DDL.Answered | 9 Replies | 32548 Views | Created by Derek Dai - Tuesday, November 13, 2007 2:58 AM | Last reply by Jim In Idaho - Wednesday, September 12, 2018 6:38 PM -
0 Votes
is it valid to have reinsertion of unique key ?
I think you should make the values unique and never reuse values.Answered | 5 Replies | 3606 Views | Created by nadirsql - Tuesday, July 20, 2010 3:50 PM | Last reply by nadirsql - Wednesday, July 21, 2010 2:13 AM -
0 Votes
UPDATE Failing with unique key constraint
you can convert it only if the unique combination doesnt break First you need to check what all columns are part of the unique key.Answered | 9 Replies | 1138 Views | Created by AmyBI - Tuesday, February 13, 2018 7:01 PM | Last reply by TiborK - Thursday, February 15, 2018 7:52 AM -
1 Votes
can we have unique key and primary key in a table?
You want to make {OrderSeqNumber, MasterBillNumber, BidSeqNumber} UNIQUE KEY (or UNIQUE INDEX)?Answered | 16 Replies | 12614 Views | Created by Incredible15 - Thursday, May 27, 2010 6:58 PM | Last reply by Kalman Toth - Friday, May 28, 2010 9:34 PM -
2 Votes
single unique key for three table
CREATE TABLE Common (UserName varchar(40) NOT NULL, Type char(1) NOT NULL, Email nvarchar(200) NOT NULL, -- Common column ...Answered | 3 Replies | 8735 Views | Created by Saksham Niranjan - Monday, October 18, 2010 1:15 PM | Last reply by Hugo Kornelis - Wednesday, October 20, 2010 9:05 PM - Items 1 to 20 of 370008 Next ›
No announcements
