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

How can I enforce to use particular index?

1 Answers   Symphony,


What is SQL server agent?

2 Answers   HCL, SAP Labs,


tell me the disaster recovery plan

0 Answers   Microsoft,


how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,


How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,






Define Foreign Key?

3 Answers   ADP, College School Exams Tests,


what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,


Why Do you want to work in this company?

4 Answers   HCL,


What is the difference between Procedure and Function

4 Answers   TCS, Accenture, Nagarro,


explain query execution plan

1 Answers  


What are the types of model in sql server and explain

2 Answers   TCS,


you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  






Categories