Interested to Buy Any Domain ? << Click Here >> for more details...
What is Left Outer Join?
- 2 Answers
- 4365 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / g.ramesh
It produce Result Set which contains matched rows and left
table unmatched rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / prasanna
The result set of a left outer join includes all the rows
from the left table specified in the LEFT OUTER clause, not
just the ones in which the joined columns match. When a row
in the left table has no matching rows in the right table,
the associated result set row contains null values for all
select list columns coming from the right table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Can sql servers linked to other servers?
What are types of scd? : sql server analysis services, ssas
What is xdr?
What is conditional split?
How to override dml statements with triggers?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What is the size of transaction log file?
Explain sql server authentication modes?
What is collation?
What is store procedure?
How do we return a record set from a Stored Procedure in SQl server 2000?
How do you create a data source?
-
Oracle (3259) - 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)
