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
- 8152 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
Can group functions be used in the order by clause in ms sql server?
What is subquery in sql?
Explain triggers?
List out what other servers you can use with ssrs?
Comment,Datatypes are unlimited
How many types of cursor type are there?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Explain difference between control flow and data flow?
What is difference between delete & truncate commands?
How to resolve the orphan use problem? : sql server security
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Does partitioning ssd reduce performance?
When I delete any data from a table, does the sql server reduce the size of that table?
Explain user defined views?
Do you know what are various aggregate functions that are available?
