Answer / sakthi

Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.

Composite key:

It same as Primary key but combination of more that one
column.

what is statistics

1 Answers  

---

How do I view a stored procedure in sql server query?

0 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

How to use clusters?

0 Answers   Amdocs,

---

Explain triggers in sql?

0 Answers  

---

Selet all the data from table where last name is n of employee

2 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---