Answer / saravakumar

You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)

Is foreign key unique?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

What is the difference between left and right outer join?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

What is SQL Server?

0 Answers   Atos Origin,

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

What are types of subqueries?

0 Answers  

---

What is a fill factor?

0 Answers  

---

What is data compression?

0 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

Create and insert into temp table in sql server?

0 Answers  

---