How can I enforce to use particular index?
Answer / saravakumar
You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)
|Is This Answer Correct ?||7 Yes||0 No|
What is Left Outer Join?
how can i lock the column in the table
What is INTVAL( )and where we use Plz any body help me
does physical index sort data
What is the basic difference between clustered and a non-clustered index?
What are the different ways of moving data/databases between servers and databases in SQL Server?
What are the differences between UNION and JOINS?
How can u get the number of pupils connecting the database?
What is Deadlock?
If a stored procedure is taking a table data type, how it looks?
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..