Tag Archive

Tag Archives for " View "

Set Yourself Apart from you Peers — Learn 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 CTE’s, the two types, and their uses.  In this article we’ll introduce CTE’s.  Once […]

Continue reading

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