No announcements

### Expert: Texttext uniqueness

it seems to work. they question is always what is a unique text?
| 12 Replies | 43 Views | Created by Anonymous - Saturday, January 3, 2009 9:43 PM | Last reply by Anonymous - Tuesday, February 3, 2009 8:57 AM

### Unique Constraint

For every expert, there is an equal and opposite expert. - Becker's Law
| 4 Replies | 7010 Views | Created by Abdul Hakeem Baloch - Saturday, October 22, 2011 3:17 AM | Last reply by Naomi N - Sunday, October 23, 2011 2:06 PM

### Unique key

For every expert, there is an equal and opposite expert. - Becker's Law
| 4 Replies | 2140 Views | Created by chrissclee - Friday, July 6, 2012 6:52 PM | Last reply by --CELKO-- - Friday, July 6, 2012 10:13 PM

### UNIQUE Constraint on table columns

You can not use CHECK CONSTRAINT for UNIQUE constraint.
| 7 Replies | 3520 Views | Created by NaplesFLdave - Tuesday, October 18, 2011 4:29 PM | Last reply by Naomi N - Tuesday, October 18, 2011 7:58 PM

### Create Unique Key Problem

It means you need to create two separate unique constraints, e.g.
| 6 Replies | 3789 Views | Created by First Programer - Thursday, October 27, 2011 3:38 AM | Last reply by First Programer - Thursday, October 27, 2011 4:36 AM

### Unique and Check Constraints

In that case, you can use a unique filtered index instead of a unique constraint: CREATE UNIQUE NONCLUSTERED INDEX idx_Test_STID_101 ON ...
| 4 Replies | 1013 Views | Created by WebRelations - Thursday, September 3, 2015 11:53 AM | Last reply by WebRelations - Thursday, September 3, 2015 9:26 PM

### Set Unique Random Number

For every expert, there is an equal and opposite expert. - Becker's Law
| 15 Replies | 3216 Views | Created by Sid Williams - Tuesday, December 1, 2015 8:29 PM | Last reply by --CELKO-- - Thursday, December 3, 2015 6:02 PM

### Violation of UNIQUE KEY constraint

For every expert, there is an equal and opposite expert. - Becker's Law
| 9 Replies | 1501 Views | Created by Rickaty - Wednesday, August 31, 2016 9:21 PM | Last reply by Naomi N - Thursday, September 1, 2016 9:54 AM

### Unique datetime from GETDATE()

The column is indexed with a unique constraint - (i'd like to remove the unique constraint, but i'm not game to - per below).
| 5 Replies | 7508 Views | Created by clay123123123 - Sunday, April 29, 2012 11:47 PM | Last reply by clay123123123 - Monday, April 30, 2012 3:29 AM

### Rest API get unique values

ListId={" + ListId + "}&FieldInternalName=" + fieldInternalName + "&ViewId={" + viewId + "}&FilterOnly=1&Filter=2", ...
| 2 Replies | 2178 Views | Created by zhw12 - Thursday, July 4, 2019 2:25 AM | Last reply by Lee__li - Thursday, July 4, 2019 6:58 AM

### Unique integer based on unique string

Map each string to a unique id?
| 21 Replies | 8837 Views | Created by simonxy - Friday, October 20, 2017 7:29 AM | Last reply by pituach - Monday, October 23, 2017 2:05 PM

### UNIQUE NONCLUSTERED INDEX or COMPOSITE PRIMARY KEY

The above is generally a bad idea unless you are a super expert and really know what you are doing.
| 8 Replies | 8563 Views | Created by PadmaSatya - Saturday, October 20, 2012 1:42 PM | Last reply by Erland Sommarskog - Saturday, October 20, 2012 8:06 PM

### uniqueness analysis - tsql.

Hi experts; I have a table with 20 columns...
| 4 Replies | 700 Views | Created by maca128 - Monday, December 21, 2015 1:48 PM | Last reply by Eric__Zhang - Tuesday, December 22, 2015 3:29 AM

### Sum unique item on group

select sum(Amount) as TotalAmount from (select distinct Client, Amount) X For every expert, there is an equal and opposite expert. - Becker's ...
| 5 Replies | 809 Views | Created by ssidenable - Sunday, July 26, 2015 6:15 PM | Last reply by ssidenable - Monday, July 27, 2015 3:57 PM

### Difference between two Unique Indexes

My Indexes have the following columns: Unique Primary Key Col1, Col3, Col4, Col5 Unique ...
| 3 Replies | 990 Views | Created by Bangaaram - Thursday, February 21, 2019 8:42 PM | Last reply by Bangaaram - Friday, February 22, 2019 1:22 PM

### Create Unique Index but it should allow Nulls.

Hi  UNIQUE index column will work like a column which is having Unique constraint.
| 7 Replies | 7185 Views | Created by OldEnthusiast - Thursday, October 27, 2011 11:46 AM | Last reply by scott_morris-ga - Wednesday, December 9, 2015 3:58 PM

### ID uniqueness

Yes, all id's are unique as described.
| 4 Replies | 6708 Views | Created by timprepscius - Wednesday, July 8, 2009 4:42 AM | Last reply by Jeff Dillon - MSFT - Thursday, August 27, 2009 12:23 AM

### Select unique records

For every expert, there is an equal and opposite expert. - Becker's Law
| 6 Replies | 1489 Views | Created by Pat Richard [Skype for Business MVP] - Thursday, May 1, 2014 5:32 PM | Last reply by Tom Cooper - Thursday, May 1, 2014 7:39 PM