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

How do you delete duplicate rows in sql server?

0 Answers  

how can you move the master database

1 Answers   IBM,

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

What are the two modes of authentication in sql server?

0 Answers  

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

What do you mean by recursive stored procedure?

0 Answers  

Disadvantages of the indexes?

0 Answers  

In which files does sql server actually store data?

0 Answers  

How much memory that we are using in Logshipping Concept?

0 Answers  

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

What is split brain scenario in DB mirroring?

1 Answers