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
- 9986 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vinoth kumar
select * from department where Dept_id
not in(select Dept_id
from employee)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Mention the differences between substr and charindex in sql server.
What is the chart in report?
What is onf in normalization form?
Explain Reporting Life Cycle?
What happens when converting big values to numeric data types?
How to create a new login name in ms sql server?
What is the difference between insensitive and scroll cursor?
What is sql server profiler trace data file?
What is self join in sql server joins?
What is the purpose of the tempdb database?
What are the 3 types of schema?
What are different backups available in sql server?
can a table be moved to different filegroup? : Sql server administration
When is the use of update_statistics command?
What is the difference between count and distinct count?
