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
- 12030 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sql pro
/*stored procedure for emplpoyee and department table
to get DeptName which has no employee records*/
select d.dept_name
from dept d
left join empl e
on d.dept_id = e.dept_id
where e.dept_id is null
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the characteristics of modern DBMS?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What are different types of collation sensitivity?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Is t sql the same as sql server?
What are the encryption mechanisms in sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Can we insert data into a view?
What structure can you implement for the database to speed up table reads?
How to use linked server?
What is rank function?
How to connect ms access to sql servers through odbc?
How will you monitor replication latency in transactional replication? : sql server replication
What are trace flags?
Explain what you mean by 3 tier architecture.
