How many types of Joins in SQL Server 2005?
Answers were Sorted based on User's Feedback
Answer / prasanna
- Equi Join
- Natural Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
|Is This Answer Correct ?||8 Yes||0 No|
Answer / mpg
There are 5 types of join in sql server 2005
|Is This Answer Correct ?||6 Yes||3 No|
Answer / rupinder kaur
there are five types:
outer join: left outer join,right outer join, full outer
cross join self join
|Is This Answer Correct ?||5 Yes||2 No|
Answer / kalyana chakravarthy maddipati
Apart all the joins above there is one more join it is
NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead
|Is This Answer Correct ?||3 Yes||0 No|
Answer / vishal
1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join
|Is This Answer Correct ?||3 Yes||1 No|
Answer / abi
Types of Joins
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
6.Cross Apply Join
7.Outer Apply Join
|Is This Answer Correct ?||2 Yes||1 No|
Answer / g.ramesh
|Is This Answer Correct ?||6 Yes||6 No|
Answer / kittu
|Is This Answer Correct ?||1 Yes||2 No|
Answer / g.ramesh
|Is This Answer Correct ?||0 Yes||2 No|
Explain log shipping and mention its advantages.
Explain “not null constraint” in sql server?
What do you mean by recursive stored procedure?
What is isnull() operator?
How to create a user name in a database?
what is denormalization and when would you go for it? : Sql server database administration
How do we return a record set from a Stored Procedure in SQl server 2000?
What is the latest version of microsoft sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
To which devices can a backup be created and where should these devices be located? : sql server management studio
can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.
What triggers long term care?