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
- 12127 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivaram pothuru
select a.*,d.* from dept a
left join emp d on a.deptno=d.deptno where d.deptno is null
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Difference between LEN() and DATALENGTH() in sql server ?
Is foreign key unique?
What purpose does the model database server?
What is a virtual table in sql?
Name three of the features managed by the surface area configuration tool? : sql server security
Describe and explain about SQL native client?
How to update muliple row in single query?
Explain sql server authentication modes?
What are the hotfixes and patches in sql server?
How do I edit a procedure in sql server?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is intellisense?
What does <> symbol mean?
What is trigger and different types of Triggers?
How much does sql server 2016 cost?
