Answer Posted / g.ramesh
Inner Join is default type of join.
It produce result set, which contain's only matched rows.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the cpu pressure?
What is the openxml statement in sql server?
What is row_number () and partition by in sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Does index speed up select statements?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the benefits of normalization?
Explain filestream storage of sql server 2008?
In which tcp/ip port does sql server run? Can it be changed?
What is a view and what are its advantages?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the difference between left and right outer join?
How to execute the cursor queries with "open" statements?
How many types of the database links?
where can you add custom error messages to sql server? : Sql server administration