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
- 10397 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Is the order of columns in the set clause important in ms sql server?
What do you mean by subquery?
How to sort the query output with order by clauses in ms sql server?
What is a derived table?
What are the functions in sql server?
How much does sql server 2016 cost?
when would you go for denormalization? : Sql server database administration
How can you insert null values in a column while inserting the data?
what are the core components of SSRS?
What are horizontal and vertical scaling?
What is executereader?
how can u get last observation in an unknown dataset ?
What are temporal tables in sql server 2016?
Give the query of getting last two records from the table in SQL SERVER?
What are the types of stored procedures in an sql server?
