Tag: sql server

Community

SQL Fundamentals

The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex but it's real

Community

ASP SQL Server Query Analyzer

This SQL Server Query Analyzer is intended to be the front page of next generation of Buildapp, which I hope to develop if time permits. As with the original Buildapp, everything is as automatic as possible, with as much useful information for developing your queries only a click or two away.

Community

Aggregate Functions in SQL

Fortunately, SQL provides aggregate functions to assist with the summarization of large volumes of data. In this three-segment article, we'll look at functions that allow us to add and average data, count records meeting specific criteria and find the largest and smallest values in a table.