how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

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

8 Answers   AON, Genpact,

---

Explain the truncate command?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

Describe in brief system database.

0 Answers  

---