Equi join and non equi join is possible with sql server?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

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  

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

What is store procedure? When do you use?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

Why functions are used in sql server?

0 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

How do I shrink an ldf file?

0 Answers  

---

What is unpivot?

0 Answers  

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---