Answer Posted / 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 |
Post New Answer View All Answers
Mention the differences between substr and charindex in sql server.
How to create a dml trigger using create trigger statements?
Explain different types of lock modes in sql server 2000?
What is the ‘fillfactor’?
What is the difference between dataadapter and datareader?
What is coalesce and check constraint in sql server?
Can a trigger be created on a view?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What do you mean by stored techniques? How would we use it?
What are the basic features of a trigger in ms sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How to rebuild all indexes on a single table?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
where can you add custom error messages to sql server? : Sql server administration
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture