Answer Posted / g.ramesh
Outter Join Produce result set,which contain matched rows
and has well has unmatched rows.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is indexed view? How to create it?
What is a full text index?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Why are you getting errors when creating a new odbc dsn?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Is it possible to call a stored procedure within a stored procedure?
What is meant by Active-Passive and Active-Active clustering setup?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is an inner join?
Explain the various types of concurrency problem?
What are the steps to follow to configure SQL*Net?
Why do we need normalization?
What do you mean by normalisation?
What is 2nf normalization form?