explain different types of jions with examples briefly?
Answer Posted / hari
Inner join
outer join--left outer join ,right outer join , full outer
join
Cross Join
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain different types of locks in sql server.
What is difference between views and tables?
What are the security related catalog views? : sql server security
What is auditing in sql server?
If we delete pack Spec what will be the status of pack Body ?
What is the cartesian product of table?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Do you know hot add cpu in sql server 2008?
What is triggers and stored procedures?
what is difference between view and Dip.
What is the language structure to add a record to a table?
Explain various data region available in ssrs with their use?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is 2nf example?
Which rendering formats are affected by the pagesize properties?