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
- 9960 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 a non clustered primary key?
What is the difference between stored procedure and functions?
What are the tool windows in sql server management studio? : sql server management studio
What is the difference between writing data to mirrored drives versus raid5 drives
What is RMS migrations?
What is sql or structured query language?
Explain about unique identifier data type in sql server?
How many types of functions are there in sql server?
How to fine-tune reports?
Explain transaction server explicit transaction?
Explain what is the function of sql server agent windows service?
Why I have to use stored procedures?
Why variables called the most powerful component of ssis?
What is openrowset sql server?
How can you know if the row fetched from cursor is still valid in underlying table?
