What are the type of joins? When do we use Outer and Self joins?
- 3 Answers
- 9353 Views
- I also Faced
- E-Mail Answers
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
What are security principals used in sql server 2005?
How do I start sql server agent automatically?
What is an identity column in insert statements?
Can sql servers link to other servers?
How do use Having,Group by,Group function in SQL?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is a database in ms sql server?
What is de-normalization in sql database administration? Give examples?
What are the advantages of partitioning?
how to do partition in sqlserver
Does a specific recovery model need to be used for a replicated database? : sql server replication
How is table type constraint applied to a table?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
is there a column to which a default can't be bound? : Sql server database administration
Mention a few common trace flags used with sql server?
