Books and articles about SQL Сменить язык на: Русский 09 December 2021 10:54:30

# Additional materials for the help at solution of exercises

AuthorAlexey Shulenin
Title

AnnotationBeing an open educational research source, the site SQL Exercises (http://sql-ex.ru/) is quite a valuable educational and methodical project, enabling within limited period of time to develop the skills of SQL use up to a master-class level.

AuthorRob Farley
Title

## Simple recursive CTE

Annotation I like CTEs. Mostly because it lets me have a derived table that I can refer to multiple times. I don't often use the recursive features of it. But when I do, I repeatedly feel amazed at the power available. Today I had a challenge to produce a nice SQL way of converting integers to binary.

Author---
Title

## Least-square method

AnnotationThis mathematical method using in solution of the exercise.

AuthorP. Voynov
Title

## Grouping of time intervals

AnnotationThis work is the conversion of Itsik Ben-Gun article in appliance to the educational base “Aeroflot”.

AuthorS. Moiseenko
Title

## String functions in MS SQL SERVER 2000

AnnotationDescription of string functions in MS SQL Server 2000.

AuthorS. Moiseenko
Title

## About the use of the operator CASE

Annotation In the help on a site the syntax of this operator is described and examples of its use are given. However these examples show an application of the CASE in the statement SELECT. Actually, the statement SELECT is the place of the most often use of the operator CASE, however it is not the only thing. We may use the CASE practically everywhere.

AuthorS. Moiseenko
Title

## About implicit conversions of SQL Server 2000 data types

AnnotationQuestions of implicit transformation of types of data in SQL are considered.

AuthorS. Moiseenko
Title

## Apology of NULL

AnnotationThe sense of application of NULL-value reveals.

AuthorS. Moiseenko
Title

## Numbering

Annotation Usually the necessity of the numbering of records occurs in forming of reports. In this case the numbering of strings returned by a query they usually realize on a client side. For example, it's easy to renumber the strings of report, prepared in MS Access. However sometimes there's the necessity to make it in this right query.

AuthorS. Moiseenko
Title

## The number-sequence generation

AnnotationHow to generate numerical sequence in query?

AuthorS. Moiseenko
Title

## Correlated subqueries

Annotation Correlated subqueries sometimes let to create the query very briefly, which can look more cumbersome when you use other means. We shall remind that correlated subquery contains reference to the query which it contains (we shall name it the main query) with the result that subquery executes for each string of the main query.


 Usage of any materials of this site is possibleonly under condition of mandatory allocation of the direct link to a sitehttp://www.sqlbooks.ruon each page where used materials are placed. Main Articles Books