Tag Archive

Tag Archives for " View "

Introduction to Common Table Expressions (CTE’s)

Common Table Expressions or CTE’s for short are used within SQL Server to simplify complex joins and subqueries, and to provide a means to query hierarchical data such as an organizational chart.  In this set of articles, we’ll introduce you to common table expressions, the two types, and their uses.  In this article we’ll introduce […]

Continue reading
4

What are the Major Part of a SQL DB?

Parts of a Database

A SQL database is used to store and retrieve data.  The database is housed in a database server and largely controlled by a database management system.  All SQL databases, whether they MS SQL Server, MySQL, Oracle, or Progress have several components in common.  They are: Tables Indexes Views Stored Procedures Triggers It is these various […]

Continue reading