This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*TODO: 1. Написать функцию GetNextLearningDay, которая определяет в какой день недели будет следующее занятие у группы; | |
| 2. Написать функцию GetNextLearningDate, которая определяет дату следующего занятия у группы; | |
| 3. При выставлении расписания нужно предусмотреть каникулы и праздничные дни; | |
| 4. Посчитать зарплату преподавателям;*/ | |
| USE PV_521_Import | |
| GO | |
| --1 | |
| CREATE OR ALTER FUNCTION GetNextLearningDay(@group AS INT) RETURNS DATE | |
| AS |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Разница в правиле исчисления високосного года. В отличие от Юлианского, где каждый 4й год считается високосным, | |
| Григорианский считает високосным год, кратный 4, кроме кратных 100, но включая годы, кратные 400. | |
| В результате Григорианский календарь точнее Юлианского, в котором год отстает от тропического примерно на 11 минут каждый год. | |
| 2.Разницы в часах между UTC и GMT нет — они совпадают. Технически разница между GMT и UTC не превышает 0,9 секунды благодаря | |
| високосным секундам. В быту разницы нет, а например в навигации, где ктитически важна точность, используют UTC | |
| 3 15 в час. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Visual Studio 2017 | |
| Test Professional: | |
| VG622-NKFP4-GTWPH-XB2JJ-JFHVF | |
| Professional: | |
| KBJFW-NXHK6-W4WJM-CRMQB-G3CDH | |
| 4F3PR-NFKDB-8HFP7-9WXGY-K77T7 | |
| Enterprise: | |
| NJVYC-BMHX2-G77MM-4XJMR-6Q8QF |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Example of `adapter' design pattern | |
| * Copyright (C) 2011 Radek Pazdera | |
| * This program is free software: you can redistribute it and/or modify | |
| * it under the terms of the GNU General Public License as published by | |
| * the Free Software Foundation, either version 3 of the License, or | |
| * (at your option) any later version. | |
| * This program is distributed in the hope that it will be useful, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Example of `adapter' design pattern | |
| * Copyright (C) 2011 Radek Pazdera | |
| * This program is free software: you can redistribute it and/or modify | |
| * it under the terms of the GNU General Public License as published by | |
| * the Free Software Foundation, either version 3 of the License, or | |
| * (at your option) any later version. | |
| * This program is distributed in the hope that it will be useful, |