Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

---

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

Explain subquery and state its properties?

0 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

How do I start and stop sql server?

0 Answers  

---

When would you use the stored procedures or functions?

0 Answers  

---