What is pivot and unpivot?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is the difference RDBMS and Graph Database?
What is Online Index Rebuild Operation?
What is normalization? Explain different forms of normalization?
what is advantages in sql 2005 over sql 2000?
What is scalar user-defined function?
What is temporary stored procedure?
Explain Active/Active and Active/Passive cluster configurations?
How to create an index on an existing table in ms sql server?
How to change a login name in ms sql server?
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?