What is difference between inner join and join?

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

What are constraints?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

Tell me about builtinadministrator?

0 Answers  

---

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What are the different types of sub-queries?

0 Answers  

---