Can you explain the types of Joins that we can have with Sql
Server?
Answer Posted / guest
There are three types of joins: Inner Join, Outer Join,
Cross Join
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between value type and reference type?
Which Model uses the SET concept
Explain nested join?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain the ways to controlling cursor behavior?
Tell me about the approaches which you used to counter the DI problems.
What is subquery explain with example?
What are trace flags and mention a few common trace flags used with sql server?
What are out-of-range errors with date and time literals?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to download and install the scaled-down database adventureworkslt?
What is hot add cpu in sql server 2008?
How to make a column nullable?
What are the restraints imposed on the table design by a merge replication?
How to bind a view to the schema of the underlying tables?