How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

---

What is the difference between left and right outer join?

0 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

How to retrieve field values using mssql_result()?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

When is update_statistics command used?

0 Answers  

---

Define tempdb database?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

What is triggers and its types?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---