No announcements
Found 187481 threads
-
0 Votes
Expert: Texttext uniqueness
it seems to work. they question is always what is a unique text?Answered | 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 -
0 Votes
Unique Constraint
For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 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 -
0 Votes
Unique key
For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 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 -
0 Votes
UNIQUE Constraint on table columns
You can not use CHECK CONSTRAINT for UNIQUE constraint.Answered | 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 -
0 Votes
Create Unique Key Problem
It means you need to create two separate unique constraints, e.g.Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
Set Unique Random Number
For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 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 -
0 Votes
Violation of UNIQUE KEY constraint
For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 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 -
3 Votes
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).Answered | 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 -
0 Votes
Rest API get unique values
ListId={" + ListId + "}&FieldInternalName=" + fieldInternalName + "&ViewId={" + viewId + "}&FilterOnly=1&Filter=2", ...Answered | 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 -
0 Votes
Unique integer based on unique string
Map each string to a unique id?Answered | 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 -
0 Votes
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.Answered | 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 -
0 Votes
uniqueness analysis - tsql.
Hi experts; I have a table with 20 columns...Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
Difference between two Unique Indexes
My Indexes have the following columns: Unique Primary Key Col1, Col3, Col4, Col5 Unique ...Answered | 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 -
0 Votes
Create Unique Index but it should allow Nulls.
Hi UNIQUE index column will work like a column which is having Unique constraint.Answered | 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 -
0 Votes
ID uniqueness
Yes, all id's are unique as described.Answered | 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 -
1 Votes
Select unique records
For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 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 -
0 Votes
Is there a built in unique identifier for records in an SQL Server table?
This is a new field to add to your table and then you can import the data - the field will be populated with unique default value.Answered | 9 Replies | 6277 Views | Created by desgordon - Thursday, July 26, 2012 8:49 PM | Last reply by Naomi N - Thursday, July 26, 2012 9:57 PM -
0 Votes
Converting string to float unique case
> I have unique case where I have NVARCHAR field [sic: columsn are not fields] with value of '1.376000000000000e+001', I need to convert this value into FLOAT and move to another field ...Answered | 5 Replies | 2614 Views | Created by Farrukh Lala - Thursday, September 6, 2012 3:20 AM | Last reply by --CELKO-- - Thursday, September 6, 2012 11:01 PM - Items 1 to 20 of 187481 Next ›
No announcements