Answer / manoj

Primary Key is a column which uniquely identifies all records in a table. For example EmployeeID column in an Employee table.

If you add another column to a PK, like (EmployeeID+FirstName) it still identifies identifies all rows uniquely, is known as Super Key.

For more interview Questions on SQL Server: http://sqlwithmanoj.wordpress.com/interview-questions/

Answer / tanmay dutta

Primary Key : Unique No. Not null.No duplicate.exam:Student_Id.
Super Key : Like (student_id + Student Name)

Answer / anil kumar dubey

A candidate key that uniquely identifies a row in a table is called primary key.
A superkey (composite key) is a combination of columns that uniquely identifies any row within a relational database management system (RDBMS) table.

How do I view a stored procedure in sql server?

0 Answers  

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

What stored by the master?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What is the security model used in sql server 2005?

0 Answers  

---

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

What are the types of indexes?

0 Answers  

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---