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

Mention the differences between substr and charindex in sql server.

0 Answers  

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

What is ACID Property of Transaction?

10 Answers  

Tell me what is the order in which the sql query is executed?

0 Answers  

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

What is the difference between value type and reference type?

0 Answers  

What are transactions and its controls?

0 Answers  

What do you understand by mirroring?

0 Answers  

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

How to find the source of a table in sql server?

0 Answers  

Can you explain powershell included in sql server 2008?

0 Answers