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 Trigger?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
what is differencial backup?how to work?Anybody explai it?
Which command displays the SQL command in the SQL buffer, and then executes it?
whats new about truncate in sql server 2008?
how to replace double quotes by single quotes in sql server
why SQL server is more used to store database rather than Access
what is package and it uses and how can u call a package
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
what is joins please explain breffly ??