Write a stored procedure for emplpoyee and department table
to get DeptName which having no employee.
Table Structure-
Emp-Emp_Id,Emp_Name,Dept_id
Dept-Dept_Id,Dept_Name
- 7 Answers
- 10399 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sql pro
/*stored procedure for emplpoyee and department table
to get DeptName which has no employee records*/
select d.dept_name
from dept d
left join empl e
on d.dept_id = e.dept_id
where e.dept_id is null
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is query and its types?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is a print index?
What is the purpose of sql profiler in sql server?
Can you insert NULL in unique column?
What is function of CUBE ?
How to deploy the Report?
Do you know the policy based administration feature of sql server 2008?
Explain syntax for dropping triggers?
Explain about unique identifier data type in sql server?
What is sql server database?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How will you hide an attribute? : sql server analysis services, ssas
