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 a ddl statement?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

Do you know how to implement service broker?

0 Answers  

What is system stored procedures?

0 Answers  

How to create a store procedure with encryption?

0 Answers  

What command is used to create a database in the sql server and how?

0 Answers  

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

how do u find least salary in a table

4 Answers  

List out different types of normalizations in sql server and explain each of them?

0 Answers  

How real and float literal values are rounded?

0 Answers  

What is the maximum size of column in sql server?

0 Answers  

What different steps will a sql server developer take to secure sql server?

0 Answers