http://www.sqlbooks.ru This resource supplys a necessary theoretical and information footing for studying of database management system (DBMS) and program languages of information sistems. All of the e-books and articles on this website are dedicated to Relational Database Management System (RDBMS) and Structured Query Language (SQL). en-us Copyright 2006, Oleg Lysenko, Serge Moiseenko oleg17l@gmail.com (Oleg Lysenko) oleg17l@gmail.com (Oleg Lysenko) Wed, 03 Mar 2006 08:50:00 GMT Articles about MS SQL Server FeedEdit 60 http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition06 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. msi77@mail.ru (Serge Moiseenko) Tue, 27 Jun 2006 10:16:12 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors056 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "For each class, define the number of ships of this class that were sunked in a battles. Result set: class, number of sunked ships." msi77@mail.ru (Serge Moiseenko) Tue, 27 Jun 2006 10:14:19 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors038&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "Find the countries having classes of both ordinary ships and cruisers." msi77@mail.ru (Serge Moiseenko) Mon, 05 Jun 2006 05:15:22 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors041&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "Define the names of all ships in the database launched before 1941." msi77@mail.ru (Serge Moiseenko) Sun, 21 May 2006 10:33:17 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors027&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Computers") on a site www.sql-ex.ru. "Define the average size of the PC hard drive for each maker that also produces printers. Result set: maker, average capacity of HD." msi77@mail.ru (Serge Moiseenko) Sun, 21 May 2006 10:32:28 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors054&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "To within two decimal digits, define the average amount of guns for all the battleships (taking into account Outcomes table)." msi77@mail.ru (Serge Moiseenko) Fri, 12 May 2006 19:24:56 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors053&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "To within two decimal digits, define the average amount of guns for the battleship classes." msi77@mail.ru (Serge Moiseenko) Fri, 12 May 2006 19:18:55 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors025&sm=id9_2 In this article meeting errors are described often at solution of Exercise 23 (database "Computer firm") on a site www.sql-ex.ru "Find the printer makers which also produce PCs with the lowest RAM and the highest-speed processor among PCs with the lowest RAM. Result set: maker." msi77@mail.ru (Serge Moiseenko) Tue, 02 May 2006 18:09:29 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors039&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "Define the ships that "survived for future battles"; being damaged in one battle, they took part in another." msi77@mail.ru (Serge Moiseenko) Tue, 02 May 2006 18:09:13 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors016&sm=id9_2 In this article meeting errors are described often at solution of Exercise 23 (database "Computer firm") on a site www.sql-ex.ru "Find the pairs of PC models having similar speeds and RAM. As a result, each resulting pair is shown only once, i.e. (i, j) but not (j, i). Result set: model with high number, model with low number, speed, and RAM." msi77@mail.ru (Serge Moiseenko) Tue, 02 May 2006 18:08:57 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors057&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "For every class that has not less than 3 ships in the database determine the number of ships of this class sunk in the battles, if any. Output: class and the number of the sunken ships." msi77@mail.ru (Serge Moiseenko) Sun, 23 Apr 2006 16:31:01 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors046&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "Point out the battles in which at least three ships of the same country took part." msi77@mail.ru (Serge Moiseenko) Thu, 20 Apr 2006 06:42:30 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors058&sm=id9_2 In this article meeting errors are described often at solution of Exercise 58 (database "Ships) on a site www.sql-ex.ru. "The weight of a shell fired by the gun, in pounds, is nearly equal to half the cube of its caliber. Define the average weight of shells for ships of each country. Take into account the ships from the Outcomes table, too." msi77@mail.ru (Serge Moiseenko) Thu, 20 Apr 2006 06:39:16 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors026&sm=id9_2 In this article meeting errors are described often at solution of Exercise 26 (database "Computer firm") on a site www.sql-ex.ru "Define the average price of the PCs and laptops produced by maker A. Result set: single total price." msi77@mail.ru (Serge Moiseenko) Thu, 13 Apr 2006 17:45:56 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition11&sm=id9_1 This work is the conversion of Itsik Ben-Gun article in appliance to the educational base “Aeroflot”. paparome@rambler.ru (P. Voynov) Fri, 07 Apr 2006 18:05:52 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition09&sm=id9_1 Description of string functions in MS SQL Server 2000. msi77@mail.ru (Serge Moiseenko) Mon, 03 Apr 2006 19:23:02 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition05&sm=id9_1 Questions of implicit transformation of types of data in SQL are considered. msi77@mail.ru (Serge Moiseenko) Thu, 30 Mar 2006 16:29:06 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors024&sm=id9_3 In this article meeting errors are described often at solution of Exercise 23 (database "Computer firm") on a site www.sql-ex.ru "Find the number of product's model (PC, PC-laptop or printer) that has the highest price. Output: model." msi77@mail.ru (Serge Moiseenko) Thu, 30 Mar 2006 16:26:25 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors035&sm=id9_3 In this article meeting errors are described often at solution of Exercise 35 (database "Ships) on a site www.sql-ex.ru. "Point out the names, displacements and number of guns of ships participating in the battle at Guadalcanal." msi77@mail.ru (Serge Moiseenko) Thu, 30 Mar 2006 16:24:09 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition02&sm=id9_1 How to generate numerical sequence in query? msi77@mail.ru (Serge Moiseenko) Thu, 30 Mar 2006 16:22:27 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition01&sm=id9_1 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. msi77@mail.ru (Serge Moiseenko) Mon, 20 Mar 2006 18:26:27 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition04&sm=id9_1 The sense of application of NULL-value reveals. msi77@mail.ru (Serge Moiseenko) Thu, 16 Mar 2006 08:59:26 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=addition03&sm=id9_1 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. msi77@mail.ru (Serge Moiseenko) Thu, 16 Mar 2006 08:58:29 GMT Additions for sql-ex.ru http://www.sqlbooks.ru/readarticle.aspx?part=09&file=errors055&sm=id9_2 In this article meeting errors are described often at solution of Exercise 55 (database "Ships) on a site www.sql-ex.ru. "For each class, define the year in which the first ship of this class was launched. Result set : class , year." msi77@mail.ru (Serge Moiseenko) Thu, 20 Apr 2006 06:40:41 GMT Additions for sql-ex.ru