How many types of Joins in SQL Server 2005?
Answer Posted / abi
Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of forms?
Mention the different types of triggers?
Explain what is lock escalation?
What is statement level trigger?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How can we solve concurrency problems?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How many databases Microsoft SQL server provides?
How do you check sql server is up and running?
Explain what is use of dbcc commands?
Explain something about security and SQL Azure?
How can you list all the columns in a database?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Why we use trigger in sql server with example?
Explain an automatic checkpoint