what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
Answer Posted / jayaraj
Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the key will act like a primary key for the
table.
| Is This Answer Correct ? | 4 Yes | 16 No |
Post New Answer View All Answers
What is in place upgrade in sql server?
What is the stuff?
what is a deadlock? : Sql server database administration
How to verify a login name with sqlcmd tool?
What is Replication?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is constraints and its types?
Can we delete data from a view?
Explain comment on transactions?
What do you do in data exploration
Can you explain what are various ways to enhance the ssrs report?
What action plan is preferred if sql server is not responding?
what exactly sql injuction.how to overcome.....
How to stop log file growing too big?
What are the tools available in market as an alternative to sql server reporting services?