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
- 12325 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivaram pothuru
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are cascading parameters in ssrs reports?
What stored procedure can you use to display the current processes?
Do you think BCNF is better than 2NF & 3NF? Why?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to transfer an existing table from one schema to another schema in ms sql server?
What does Master database contains?
Please illustrate physical database architecture? : SQL Server Architecture
Explain Geography datatype in SQL Server
How to rebuild the master database?
what is bit datatype? : Sql server database administration
Why are you getting errors when creating a new odbc dsn?
Who is the owner of a schema in ms sql server?
How to provide column names in insert statements in ms sql server?
How do you check sql server is up and running?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
