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
If a stored procedure is taking a table data type, how it looks?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to use go command in "sqlcmd"?
what is the sql equivaent of the dataset relation object ?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What method is used by the Command classes to execute SQL statements that return single values?
What is difference between rollback immediate and with no_wait during alter database?
Where are SQL server users names and passwords are stored in sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the different editions available in sql server 2000?
What are the differences between user defined functions and stored procedures?
What is precedence constraint?
What are click through reports?
What the different components of Replication and what is their use?