This file contains 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
#include <iostream> | |
#include <curl/curl.h> | |
#include <string> | |
using namespace std; | |
/* | |
1) заходим на https://github.com/microsoft/vcpkg | |
2) качаем архив (code > download) | |
3) распаковываем архив, переносим файлы в C:\vcpkg | |
4) запускаем bootstrap-vcpkg.bat, в папке сформируется vcpkg.exe |
This file contains 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
AndroidManifest.xml: | |
<?xml version="1.0" encoding="utf-8"?> | |
<manifest xmlns:android="http://schemas.android.com/apk/res/android" | |
xmlns:tools="http://schemas.android.com/tools"> | |
... | |
<uses-permission android:name="android.permission.INTERNET" /> | |
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" /> | |
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" /> | |
... |
This file contains 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
AndroidManifest.xml: | |
... | |
<uses-permission android:name="com.android.alarm.permission.SET_ALARM" /> | |
... | |
============================================================================================== | |
MainActivity.java: |
This file contains 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
MainActivity.java: | |
package com.sunmeat.calendar; | |
import android.Manifest; | |
import android.content.ContentResolver; | |
import android.content.ContentValues; | |
import android.content.Context; | |
import android.content.pm.PackageManager; | |
import android.os.Build; |
This file contains 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
AndroidManifest.xml: | |
... | |
<uses-feature | |
android:name="android.hardware.telephony" | |
android:required="false" /> | |
<uses-permission android:name="android.permission.CALL_PHONE" /> | |
<uses-permission android:name="android.permission.READ_PHONE_STATE" /> | |
... |
This file contains 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
DECLARE @a float = 26.32 | |
DECLARE @b float = 24.1 | |
DECLARE @c float = 46.12 | |
PRINT (@a + @b + @c) / 3 | |
IF DATEPART(HOUR, GETDATE()) BETWEEN 4 AND 11 | |
BEGIN | |
PRINT 'С добрым утром!' | |
END |
This file contains 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
ELECT p.name, pr.name | |
FROM Products p RIGHT OUTER JOIN Producer pr ON p.id_producer = pr.id | |
SELECT p.name, c.name | |
FROM Products p RIGHT OUTER JOIN Category c ON p.id_category = c.id | |
WHERE p.name IS NULL | |
SELECT name | |
FROM Region | |
EXCEPT |
This file contains 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
SELECT p.name | |
FROM Sale s JOIN Products p ON s.id_product = p.id | |
WHERE s.price > 50 | |
SELECT c.name | |
FROM Delivery d JOIN Products p ON d.id_product = p.id | |
JOIN Category c ON p.id_category = c.id | |
WHERE d.price >= 50 | |
This file contains 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
USE Products | |
-- Task 1 | |
SELECT p.name, c.name, pr.name | |
FROM Products p JOIN Category c | |
ON p.id_category = c.id | |
JOIN Producer pr | |
ON p.id_producer = pr.id | |
WHERE p.id_producer <> 1 AND p.id_producer <> 2 | |
AND pr.name NOT LIKE '%[АКМ]%' AND p.id_category <> 3 |
This file contains 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
USE Store | |
SELECT * | |
FROM Product | |
WHERE DATEDIFF(M, date_of_delivery, GETDATE()) <= 1 | |
SELECT name, price | |
FROM Product | |
WHERE producer = 'Roshen' AND category = 'Кондитерские изделия' |
NewerOlder