SQL SERVER Tips and Tricks

Bookmark
  • Home
  • Video Tutorial
  • Interview Questions
  • Performance Tuning
  • SQL EXAMPLES
Search: 
  Go

Categories

  • Examples (15)
  • INTRODUCTION (14)
  • Join in SQL Server (8)
  • Miscellaneous (5)
  • SQL SERVER COMMANDS (29)
  • SQL SERVER DDL COMMANDS (3)
  • SQL SERVER DML COMMANDS (8)
  • SQL SERVER Error Messages (4)
  • SQL SERVER FUNCTIONS (10)
  • SQL SERVER GENERAL QUESTIONS (28)
  • SQL SERVER GENERAL SCENARIOS (1)
  • SQL Server Installation (1)
  • SQL SERVER Interview Questions (8)
  • sql server performance tuning tips (3)
  • SQL SERVER Tutorial for the Beginners (1)
  • Stored Procedures (20)
  • Templates (6)
  • white papers (1)

Archives

  • ▼  2012 (144)
    • ►  January (9)
    • ►  March (2)
    • ▼  April (46)
      • Commands in SQL SERVER
      • TCL Command in SQL SERVER
      • DCL Commands in SQL SERVER
      • DDL Commands in SQL SERVER: CREATE
      • DDL Commands in SQL SERVER: ALTER
      • DDL Commands in SQL SERVER : DROP
      • DDL Commands in SQL SERVER: TRUNCATE
      • DML Commands in SQL SERVER : INSERT (Part 1)
      • DML Commands in SQL Server: INSERT (Part 2) -- Ins...
      • DML Commands in SQL Server: UPDATE
      • DML Commands in SQL Server: SELECT
      • DML Commands in SQL Server: DELETE
      • Whats Difference between DELETE and TRUNCATE Comma...
      • SQL Server Interview Questions: Part1
      • SQL Server Interview Questions: Part2
      • SQL Server Interview Questions: Part3
      • SQL Server Interview Questions: Part4
      • How to enable OPENROWSET in SQL SERVER?
      • General Error messages in SQL SERVER
      • SELECT in SQL SERVER
      • TOP in SQL Server
      • WHERE Clause in SQL Server
      • IN Clause in SQL Server
      • BETWEEN in SQL Server
      • DISTINCT in SQL Server
      • How to drop all the tables from database in SQL Se...
      • ORDER BY in SQL Server
      • GROUP BY in SQL Server
      • Group By Errors in SQL Server
      • HAVING Clause in SQL Server
      • Aggregate Functions in SQL Server
      • COUNT in SQL SERVER
      • SUM in SQL Server
      • MAX Function in SQL Server
      • MIN in SQL SERVER
      • AVG in SQL SERVER
      • What is the difference between HAVING and WHERE in...
      • SELECT ,DISTINCT, FROM, WHERE, GROUP BY,HAVING an...
      • Joins in SQL SERVER
      • INNER JOIN in SQL Server
      • LEFT OUTER JOIN in SQL Server
      • RIGHT OUTER JOIN in SQL SERVER
      • FULL OUTER JOIN in SQL SERVER
      • CROSS JOIN in SQL SERVER
      • SQL Server Interview Questions: Part5
      • SELF JOIN in SQL SERVER
    • ►  May (53)
    • ►  August (26)
    • ►  September (6)
    • ►  November (1)
    • ►  December (1)
  • ►  2013 (4)
    • ►  February (1)
    • ►  November (1)
    • ►  December (2)

SQL Server Interview Questions: Part5

Posted on Thursday, 26 April 2012 by SQL Developer

  1. What are the Different types of Joins in SQL Server?
  2. Describe about Inner Join in SQL Server?
  3. Describer about Left Outer Join in SQL SERVER?
  4. Describer about Right Outer Join in SQL SERVER?
  5. Describer about Full Outer Join in SQL SERVER?
  6. Describer about Cartesian Product in SQL SERVER?
  7. Describer about CROSS Join in SQL SERVER?
  8. Describer about SELF Join in SQL SERVER?
  9. If table A have 'X' records and table B have 'Y' records, then Cartesian product will have how many records?
  10. Significance of JOIN in SQL Server?

Email ThisBlogThis!Share to XShare to Facebook
This entry was posted in SQL SERVER Interview Questions . Bookmark the permalink.
Newer Post »
«Older Post

Leave a reply

About

This blog is created to provide complete solutions for all possible problems in SQL SERVER. It contains SQL SERVER Performance techniques, SQL SERVER Interview questions and complete SQL Tips.

Followers

Copyright © 2012 SQL SERVER Tips and Tricks