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.

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

How sql server enhances scalability of the database system?

0 Answers  

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What are the different types of sql server replication? : sql server replication

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

Define inner join? Explain with an example?

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

What is the difference between commit and rollback?

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---