create proc DeptName begin select * from emp full join dept on emp.deptno

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 / ayush

7 Answers
12308 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / ayush

create proc DeptName
begin
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
end

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

You want to use a perspective in an mdx query. How do you select the perspective?

246

What are the advantages of partitioning?

1178

What are trace flags?

1086

What are policy management terms?

1040

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

1101

Explain logical operators in sql server?

1184

What type of locking occurs during the snapshot generation? : sql server replication

1375

How to concatenate two character strings together?

1168

What is the difference between function and stored procedure in sql server?

1154

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

What is check constraint in sql server?

1047

How do you set a trace flag in sql server?

1094

What is a coalesce function?

1250

What is data source in connection string?

958

What are page splits? : SQL Server Architecture

1039