CREATE PROCEDURE GetDept AS SELECT Dept_name from dept WHERE Dept

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

Question Posted / unnikrishnan nair r

7 Answers
12300 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

Please Help Members By Posting Answers For Below Questions

What are the different types of replication are there in sql server 2000?

1085

What are the different types of normalization?

1218

How can you list all the columns in a database?

969

Can you insert NULL in unique column?

1207

can we have a nested transaction? : Sql server database administration

1186

Explain what is “asynchronous” communication in sql server service broker?

954

Mention the different types of replication in sql server.

1068

What is difference between rollback immediate and with no_wait during alter database?

1130

what are the different stages of Report Processing?

141

How many types of schemas are there?

1091

Explain full-text query in sql server?

1051

How do I view a script in sql server?

1082

List the ways in which dynamic sql can be executed?

1057

what is spatial nonclustered index

1033

Â Explain what is sql override for a source taLle in a mapping?

1052