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
- 11826 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
What are the differences between user defined functions and stored procedures?
Explain the stored procedure?
Where are sql server usernames and passwords stored in the sql server?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is your recommendation for a query running very slow? : sql server database administration
How to deploy the Report?
How efficient you are in oracle and SQL server?
when you create a database how is it stored? : Sql server database administration
What type of Index will get created after executing the above statement?
Explain aggregate functions?
How to make remote connection in database?
Explain what are the events recorded in a transaction log?
Explain what role entity and relationship play in an ER diagram.
What is the use of set nocount on/off statement?
How can I change procedure name in sql server?
