What is a join and their types?
Answer Posted / hari
Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is store procedure? How do they work?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Difference between report and query parameter. Why do we need different type of parameter?
What is an execution plan? When would you use it?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is RMS migrations?
What are distinctive joins find as a part of sql?
How to send a ssrs report from ssis?
How to provide default values to stored procedure parameters?
How to store and query spatial data?
What is ems sql management studio? : sql server management studio
What happens if null values are involved in datetime operations?
What are triggers? How do you invoke a trigger on demand?
What do you understand by integration services in sql server?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?