Answer / madhuparna bhaumik

/*stored procedure for emplpoyee and department table
to get DeptName which having no employee*/

CREATE PROCEDURE sp_myStoredProcedure
AS
select * from emp full join departments on
emp.department_id=departments.department_id
where employee_id is null;
Go

Answer / vinoth kumar

select * from department where Dept_id
not in(select Dept_id
from employee)

Answer / ayush

create proc DeptName
begin
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
end

Answer / sivaram pothuru

select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;

Answer / unnikrishnan nair r

CREATE PROCEDURE GetDept
AS
SELECT Dept_name from dept
WHERE Dept_Id NOT IN(SELECT DISTINCT Dept_id FROM Emp )

Answer / 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

Answer / sivaram pothuru

select a.*,d.* from dept a
left join emp d on a.deptno=d.deptno where d.deptno is null

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

Can a unique index be created on a column, which contains null?

0 Answers  

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

Why is sql server log file full?

0 Answers  

What are orphan records?

0 Answers  

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

What is a join in sql? What are the types of joins?

0 Answers  

What is the difference between a view and a stored procedure?

0 Answers  

How to update muliple row in single query?

0 Answers   MCN Solutions,

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

What are the parts of a function?

0 Answers