Interested to Buy Any Domain ? << Click Here >> for more details...
what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
- 2 Answers
- 8251 Views
- I also Faced
- E-Mail Answers
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 the different components of Replication and what is their use?
What does top operator do?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is difference between equi join and natural join?
What is stretch database in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Can we insert data into a view?
When would you use the stored procedures or functions?
How can I check that whether automatic statistic update is enabled or not?
How to create sub reports?
How do I setup a sql server database?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are translations and its use? : sql server analysis services, ssas
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is sql azure database?
