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
- 12299 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
How do I create a stored procedure in dbml?
How to provide values to user defined function parameters?
What is the difference between left and right outer join?
What does dml stand for?
What are the types of indexing?
What is the use of RDBMS?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are the purposes and advantages stored procedure?
Is it safe to delete log files?
How do you create an execution plan?
What is instead of trigger sql server?
How do you migrate data from mssql server to azure?
What are data regions?
Can we add a cpu to sql server?
What is TDS(Tabular Data Stream) Gateway?
