unique

Solo answered Apr 19, '19 Default

What is the difference between PRIMARY KEY and UNIQUE constraints?

This question has an accepted answer. Accepted

4 Likes

6Answers

0 Comments

Pike asked Nov 7, '18 Default

Unable to identify missing record using view

tsql temporary-table unique

0 Likes

0Answers

0 Comments

anthony.green commented Nov 5, '15 Default

Find the pairs that appear the most times in StoreID and each STOREID has only this pair SQL

sql aggregates unique aggregation

0 Likes

0Answers

1 Comment

Tom Staab commented Aug 5, '15 Default

How to find the top 2 records for each unique id

select distinct unique

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

EuniceRH commented Apr 13, '15 Default

two separate tables or two uniquifying foreign keys

index foreign-key unique

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

GPO edited Oct 4, '14 Default

NULLs and unique key

sql-server-2008-r2 null unique

This question has an accepted answer. Accepted

2 Likes

1Answer

1 Comment

GPO commented Sep 3, '14 Default

Indexes: To unique or not unique

nonclustered-index unique

This question has an accepted answer. Accepted

3 Likes

1Answer

0 Comments

technette commented Nov 14, '13 Default

Select unique reference number and associated data

select unique

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

Kev Riley commented Jan 29, '13 Default

UNIQUE NONCLUSTERED INDEX with INCLUDE columns

sql-server-2008-r2 indexing unique

This question has an accepted answer. Accepted

2 Likes

1Answer

0 Comments

stevenjgarner edited Apr 29, '12 Default

Best MySQL practice to insert a record if it does not already exist, and return its id

update select mysql insert unique

1 Like

2Answers

0 Comments

JD asked Sep 17, '11 Default

Secuence-like type fields in MSSQL

unique key

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

Raj More asked Jun 29, '11 Default

ETL Consideration: Constraint vs. Index vs. Check in query

etl unique

This question has an accepted answer. Accepted

1 Like

3Answers

0 Comments

TelepathicSheep asked Apr 11, '11 Default

want to create table, from multiple views - where primary key will be several fields?

table view create unique

This question has an accepted answer. Accepted

1 Like

1Answer

1 Comment

Fatherjack asked Sep 1, '10 Default

Indexing a GUID

indexing primary-key unique

This question has an accepted answer. Accepted

3 Likes

3Answers

0 Comments

hardingr2000 asked Aug 2, '10 Default

FULL-TEXT Search: Help Needed with the Unique Key Requirement

index full-text search unique

1 Like

1Answer

0 Comments

What is the difference between PRIMARY KEY and UNIQUE constraints?

Unable to identify missing record using view

Find the pairs that appear the most times in StoreID and each STOREID has only this pair SQL

How to find the top 2 records for each unique id

two separate tables or two uniquifying foreign keys

NULLs and unique key

Indexes: To unique or not unique

Select unique reference number and associated data

UNIQUE NONCLUSTERED INDEX with INCLUDE columns

Best MySQL practice to insert a record if it does not already exist, and return its id

Secuence-like type fields in MSSQL

ETL Consideration: Constraint vs. Index vs. Check in query

want to create table, from multiple views - where primary key will be several fields?

Indexing a GUID

FULL-TEXT Search: Help Needed with the Unique Key Requirement

Followers

Topic Experts

Related Topics

unique

All Questions

Followers

Topic Experts

Related Topics