Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12139 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 are the different normalization forms?
Explain what is lock escalation?
What is query optimizer in sql server?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is an execution plan? How would you view the execution plan?
How do you create an execution plan?
What is difference between commit and rollback when used in transactions?
Explain what is dbcc?
What are the differences between local and global temporary tables?
what are the new features in SSRS?
What are the advantages of policy management?
What is identity?
How to download and install microsoft sql server management studio express?
Can we delete data from a view?
