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
What is the difference between substr and charindex in the sql server?
How do you handle datasets larger than 50 gb?
what are cursors? : Sql server database administration
What is difference between rownum and rowid?
what data regions are and what are the different data regions?
What is meant by dirty read?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Is BCNF better than 2NF & 3NF? Why?
What are policy management terms?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Do you know what is sql injection?
Are resultset updatable?
What happens if date-only values are provided as date and time literals?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is compression - row-level and page-level compression?