What are the type of joins? When do we use Outer and Self joins?
Answer Posted / shivanibehere
http://www.tomjewett.com/dbdesign/dbdesign.php?
page=jointypes.php&imgsize=medium
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the differences between having and where clause.
Why normalization is used?
What is replication with database mirroring? : sql server database administration
What happens if time-only values are provided as date and time literals?
When you use @@error and try-catch?
How extra digits are handled with numeric data type literals?
What is report snapshot?
What is difference between rollback immediate and with no_wait during alter database?
What is enhanced database mirroring in sql server 2008?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How to set the current database in ms sql server?
How to use column default values in insert statements in ms sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Explain how many normalization forms?
What does the not null constraint do?