Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / swapna


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 to connect to a sql server using odbc_connect()?

0 Answers  

Why we use functions in sql server?

0 Answers  

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

Explain the first normal form(1nf)?

0 Answers  

Explain view in sql server?

0 Answers  

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

How to create a view using data from another view?

0 Answers  

How to check status of stored procedure in sql server?

0 Answers  

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

What is proper subset of candidate key?

0 Answers  

optimization techinques

0 Answers   Wipro,

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

For more SQL Server Interview Questions Click Here
Categories