primary-key Image

primary-key

question
Jeff Moden avatar image
Jeff Moden answered Default

ID is primary key value increasing by +15 or +random number every time I add a row

table sqlserver tables primary-key

0 Likes

1Answer

0 Comments

question
Pranjali13 avatar image
Pranjali13 edited Default

What is a primary key?

database-design primary-key

This question has an accepted answer. Accepted

2 Likes

4Answers

1 Comment

question
Pranjali13 avatar image
Pranjali13 answered Default

How to find candidate keys from a set of super keys?

primary-key

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

Once again, Why Primary Key should not be included in Non Clustered index?

primary-key clustered-index nonclustered-index missing-index included-columns

0 Likes

1Answer

0 Comments

question
DaveC avatar image
DaveC edited Default

Primary Keys creating new

primary-key

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Solo avatar image
Solo answered Default

What is the difference between PRIMARY KEY and UNIQUE constraints?

primary-key constraint unique

This question has an accepted answer. Accepted

4 Likes

6Answers

0 Comments

question
equipe9 avatar image
equipe9 answered Default

Clustered vs Non Clustered Indexes for a Primary Key

sql server indexes primary-key clustered-index nonclustered-index

0 Likes

2Answers

0 Comments

question
rehaan avatar image
rehaan commented Default

Capture Primary key violation error and send an alert

primary-key error-handling alerts

0 Likes

1Answer

1 Comment

question
Oleg avatar image
Oleg rolled back Default

How to write a merge statement in SQL

ssms merge primary-key union

This question has an accepted answer. Accepted

1 Like

3Answers

0 Comments

question
tlenzmeier avatar image
tlenzmeier commented Default

Do I Need a "Master" table?

sql server primary-key relationships

0 Likes

0Answers

3 Comments

question
Oleg avatar image
Oleg commented Default

Identity Column in Concurrency, Multithreading, Parallel Processing

sql server 2012 database-design transaction primary-key parallelism

0 Likes

0Answers

1 Comment

question
Oleg avatar image
Oleg answered Default

remove some rows based on primary key values

t-sql primary-key foreign-key table-valued

0 Likes

2Answers

2 Comments

question
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered Default

Composite Primary key

primary-key composite

0 Likes

1Answer

0 Comments

question
sjimmo avatar image
sjimmo answered Default

2 columns primary key problem

primary-key

0 Likes

3Answers

0 Comments

question
Wilfred van Dijk avatar image
Wilfred van Dijk commented Default

Primary Key on SQL Server Table

sql-server primary-key

1 Like

1Answer

0 Comments

50 Posts
48 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.