What the different components of Replication and what is their use?

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What is the command to change the recovery model?

0 Answers  

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

Explain what is the main purpose of having conversation group?

0 Answers  

---

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

---

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

What is a not null constraint?

0 Answers  

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---