The exercises that we have considered earlier in Chapters 3-4, make up the initial stage (or the learning stage) of testing on a site. These are rather simple problems the solutions of which, as a rule, do not require knowledge of features of realization. It means that the solutions practically can be received in the framework of Standard SQL-92.
On the second-stage challenges, solutions require knowledge of specific realization, for example, string functions or functions of treatment of date/time values.
Exercises of this stage are not considered in the book as results of their solutions on a site allow you to earn the certificate. Nevertheless, we consider necessary to acquaint the reader with specific features 
Cистема управления реляционными базами данных (СУБД), разработанная корпорацией Microsoft. SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.SQL Server, and also with some algorithmic receptions which can be applied to the solution of exercises on a site as well as to decision of the problems often arising in practice.
go
(Chapter 7)