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

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

What is user defined stored procedures?

0 Answers  

How do you rebuild an identity column?

0 Answers  

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

What is field with example?

0 Answers  

What is a database table?

0 Answers  

Explain a join?

0 Answers  

What is subquery explain with example?

0 Answers  

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

What is BLOCK statements in SQL?

0 Answers   HCL,

Explain about remote stored procedure?

0 Answers