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?






Suppose in a situation if two list boxes are there and if you select multiple options based on that..

Answer / pawan k. dubey

e.g. create two table
1-department(dept_id int PK,dept_name)
2-employee(emp_id int Primary key,Name varchar(40),dept_id
FK)

now create two listbox employee and department.

step1-when multiple departments are selected...dispaly
employee related to selected department in employee listbox

step2-when multiple employees are selected...dispaly
respective department in department listbox

Is This Answer Correct ?    1 Yes 1 No

Post New Answer




More SQL Server Interview Questions

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  


what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  


what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,


What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,


Where do you think the users names and passwords will be stored in sql server?

4 Answers  






Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  


If we use where clause in the left outer join then how the query would behave/act?

1 Answers  


What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  


What is trigger ?

7 Answers   Cap Gemini, SQL,


How to know whether our backup is succesfully taken?

1 Answers  


How can I enforce to use particular index?

1 Answers   Symphony,


What are the OS services that the SQL Server installation adds?

3 Answers  






Categories