How many types of Joins in SQL Server 2005?
Answer Posted / kittu
inner join
outer join
cross join
equi join
self join
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
When would you use sql joins?
What is the importance of three tier architecture?
How can you start sql server in different modes?
What are the dmvs?
What is normalization and its types?
How to throw custom exception in Stored Procedure?
What is the difference between getdate and sysdatetime?
What is the dbcc command and why is it used?
List some of the rules that apply to creating and using a ‘view’
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Are null values the same as that of zero or a blank space?
How to convert a numeric expression from one data type to another?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Explain the difference between control flow and data flow?
Explain the etl (extraction, transformation, and loading)?