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
- 9973 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ayush
create proc DeptName
begin
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
end
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
User wants only to display only pdf as export option in report manager. How to achieve this?
How to download and install microsoft .net framework version 2.0?
How to count duplicated values in a column in ms sql server?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How do you delete a trigger?
Do you know data definition language, data control language and data manipulation language?
What is a filestream?
What is triggers and its types?
Can group functions be mixed with non-group selection fields in ms sql server?
Will the writetext statement activate a trigger?
How to make a remote connection in a database?
Is sql server difficult to learn?
List few advantages of stored procedure.
How to configure odbc dsn with different port numbers?
Why would you call update statistics?
