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
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?
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
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|
can you any body tell me why are go for the rebuild the master database.what is the reason?
what is mean by crystal repoart? ahere we will mainly use that?
what is Buffer cash and Log Cache? Can you Explain it?
What is WITH CHECK OPTION
Where do you think the users names and passwords will be stored in sql server?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
If we use where clause in the left outer join then how the query would behave/act?
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
What is trigger ?
How to know whether our backup is succesfully taken?
How can I enforce to use particular index?
What are the OS services that the SQL Server installation adds?