Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 19 March 2024 13:21:07


www.sql-ex.ru
Skip Navigation Links  

 

Additional materials for the help at solution of exercises


AuthorAlexey Shulenin
Title

Microsoft's employee about SQL-EX.RU

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 possible
only under condition of mandatory allocation of the direct link to a site
http://www.sqlbooks.ru
on each page where used materials are placed.

 Main   Articles    Books 
Рейтинг@Mail.ru Rambler's Top100 Alt Упражнения по SQL: обучение, тестирование, сертификация по языку SQL Copyright c 2002-2006. All rights reserved.