How many types of Outer Joins?What are they?
Answer / g.ramesh
We have 3 Types of Outer Joins.
1.Left Outer Join
2.Right Outer Join
3.Full Outer Join
| Is This Answer Correct ? | 12 Yes | 0 No |
What is the use of sql profiler in sql server 2012?
What is the stuff and how does it differ from the replace function?
What is the purpose of data source?
Do you know the different ddl commands in sql?
What is the Control Flow in SSIS
Explain log shipping?
what is the output for this query select * from employee where 1=1;
What are the differences between UNION and JOINS?
3 Answers CarrizalSoft Technologies,
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
If the job running very slow what is the action you do
What is partition index in sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
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)