Write a stored procedure for emplpoyee and department table
to get DeptName which having no employee.
Table Structure-
Emp-Emp_Id,Emp_Name,Dept_id
Dept-Dept_Id,Dept_Name
- 7 Answers
- 10842 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / unnikrishnan nair r
CREATE PROCEDURE GetDept
AS
SELECT Dept_name from dept
WHERE Dept_Id NOT IN(SELECT DISTINCT Dept_id FROM Emp )
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the default value of an integer data type in sql server 2005?
How you can change a cross join into an inner join?
What is open database communication (odbc)?
What is sql injection and why is it a problem? : sql server security
Explain what is log shipping?
how can you check the level of fragmentation on a table? : Sql server administration
What is the contrast amongst drop and truncate?
Is BCNF better than 2NF & 3NF? Why?
Define compound operators?
What are the filtered indexes?
What is partitioned view?
What is executereader?
Define right outer join?
What type of locking occurs during the snapshot generation? : sql server replication
Distinguish between commit and rollback?
