Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11837 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
Are all views updatable ?
How to create a trigger for insert only?
What are approximate numeric data types in ms sql server?
What is the parse query button used for?
Is foreign key a primary key?
Mention the differences between sql server and mysql.
How to select an exiting database using mssql_select_db()?
How to get nth highest salary from employee table.
What is a View ? Can we insert, Update and delete a view?
What is a natural primary key?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How to use column default values in insert statements in ms sql server?
What is a dataset and what are the different types of datasets?
Difference between uniqe index and uniqe constraint?
Is it possible in sql table to have more than one foreign key?
