page contents
Archive | March, 2014

Types of MSSQL Joins

In Microsoft SQL Server, we have four types of joins. We use these joins to fetch data from multiple tables that are based on a condition. A join condition is a relationship among some columns in the data tables that take part in SQL join. Basically data tables are related to each other with keys. […]

1 Comment Continue Reading →

Language components of Structured Query Language (SQL)

Recently, I have been working on improving my querying ability in Microsoft SQL and have been reading Itzik Ben-Gan’s book. I thought I had written this topic in an earlier and to my surprise I was wrong. A good fundamental bit of information to know as I progress through data structures and the language used to […]

Comments Off on Language components of Structured Query Language (SQL) Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.