What is the difference between cross join and Full outer
join?
Answer / soma shaw
A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.
| Is This Answer Correct ? | 18 Yes | 0 No |
explain extended properties
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Explain datetime2 data type in sal server 2008?
What is the difference between sdf and mdf?
What are xml indexes?
What is abstracting periodical?
What is transaction server consistency?
Tell me what is log shipping?
Explain the commands in sql server?
Explain the relational database management system (rdbms)?
What is for xml in sql server?
can foreign key take role of primary key?
5 Answers CarrizalSoft Technologies, TCS, Villa Marie,
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)