Answer / arun anoop m

We use Self Join, if we have a table that references itself.


For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.

How to enforce security in sql server? : sql server security

0 Answers  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

How to connect sql server management studio express to sql server 2005 express?

0 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

---

What sql server means?

0 Answers  

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---