Apart all the joins above there is one more join it is NO EQUI JOIN ie

How many types of Joins in SQL Server 2005?

Question Posted / kalyana chakravarthy maddipati

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain four layers of abstraction microsoft architectured?

147

What is replication and database mirroring?

990

What is mean by dml?

943

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

962

Define cursor locking

944

What is shrink log file?

840

What is check constraint in sql server?

951

Can we update data in a view?

968

Explain the properties of a relational table?

975

What is index fragmentation in ms sql server?

1019

Explain different types of Normalization.

1729

Explain the xml support sql server extends?

978

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1031

List the advantages of using stored procedures?

996

which backup strategy you are following at ur company

2103