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
- 12121 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ayush
create proc DeptName
begin
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
end
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to create a store procedure with encryption?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is db stored procedure?
What are the characteristics of modern DBMS?
What is xdr?
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
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Explain system scalar functions?
How to convert binary strings into integers in ms sql server?
Explain four layers of abstraction microsoft architectured?
Mention the different types of triggers?
How can change procedure in sql server?
How to find out the list schema name and table name for the database?
Can you pass expressions to stored procedure parameters?
