|
Author | Alexey Shulenin |
Title |
|
Annotation | Being 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. |
|
Author | Rob Farley |
Title |
|
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 |
|
Annotation | This mathematical method using in solution of the exercise. |
|
Author | P. Voynov |
Title |
|
Annotation | This work is the conversion of Itsik Ben-Gun article in appliance to the educational base “Aeroflot”. |
|
Author | S. Moiseenko |
Title |
|
Annotation | Description of string functions in MS SQL Server 2000. |
|
Author | S. Moiseenko |
Title |
|
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.
|
|
Author | S. Moiseenko |
Title |
|
Annotation | Questions of implicit transformation of types of data in SQL are considered. |
|
Author | S. Moiseenko |
Title |
|
Annotation | The sense of application of NULL-value reveals. |
|
Author | S. Moiseenko |
Title |
|
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.
|
|
Author | S. Moiseenko |
Title |
|
Annotation | How to generate numerical sequence in query? |
|
Author | S. Moiseenko |
Title |
|
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.
|