How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

What is sql server profiler trace data file?

0 Answers  

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

Does sql server use t sql?

0 Answers  

---

What are the grouping functions?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

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

0 Answers   TCS,

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---