Loading repository data…
petrfaltus / repository
Console applications for connection to the Microsoft SQL Server, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
Small example console source codes how to connect to the Microsoft SQL Server, how to update rows and how to read the table.
git clone https://github.com/petrfaltus/ms-sql-server-connection-source-codes.gitThe subdirectory docker-database contains prepared Windows batches:
01-run-database.cmd - pulls the image and runs the container at the first time02-switch-database-OFF.cmd - stops the already existing container02-switch-database-ON.cmd - starts the already existing container03-inspect-database.cmd - shows details for already existing container04-exec-connection-to-database-sa.cmd - executes the sqlcmd tool terminal into running database container (as the user sa)04-exec-connection-to-database-testuser.cmd - executes the sqlcmd tool terminal into running database container (as the user testuser)containers.cmd - lists currently running containers and list of all existing containersFor the connection to the database use either the sqlcmd tool terminal or the Microsoft SQL Server Management Studio
Selected from shared topics, language and repository description—not editorial ratings.
petrfaltus /
Console applications for a network TCP and UDP socket communication over IPv4 and IPv6. Senders and receivers, complete example collection. Code for Java, for C# built by the .NET Framework, for PHP and for Python.
31/100 healthpetrfaltus /
Console applications for connection to the Oracle database, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.
31/100 healthUse prepared Windows batches, every SQL command terminate by the keyword GO
SELECT @@version;
GO
User sa (default password Syst3mAdm1n!)
User testuser (default password T3stUs3r!)
CREATE DATABASE testdb;
USE testdb;
CREATE LOGIN testuser WITH PASSWORD = 'T3stUs3r!';
CREATE USER testuser FOR LOGIN testuser;
GRANT SELECT TO testuser;
GRANT CREATE TABLE TO testuser;
GRANT INSERT TO testuser;
GRANT UPDATE TO testuser;
GRANT ALTER TO testuser;
GRANT EXECUTE TO testuser;
ALTER LOGIN testuser WITH DEFAULT_DATABASE=testdb;
USE testdb;
CREATE TABLE animals (
name VARCHAR(40) NOT NULL,
legs TINYINT NOT NULL,
created DATETIME DEFAULT GETDATE(),
updated DATETIME,
remark VARCHAR(80),
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL
);
CREATE TRIGGER animals_update
ON animals
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE animals
SET updated = GETDATE()
WHERE id IN (SELECT id FROM Inserted)
END;
INSERT INTO animals (name, legs) VALUES ('chicken', 2);
INSERT INTO animals (name, legs) VALUES ('fox', 4);
INSERT INTO animals (name, legs) VALUES ('eagle', 2);
INSERT INTO animals (name, legs) VALUES ('ant', 6);
INSERT INTO animals (name, legs) VALUES ('horse', 4);
CREATE OR ALTER FUNCTION factorial(@n INT) RETURNS INT AS
BEGIN
IF (@n < 0)
RETURN -1;
DECLARE @result INT = 1;
IF (@n < 2)
RETURN @result;
DECLARE @ijk INT = 2;
WHILE @ijk <= @n
BEGIN
SET @result = @result * @ijk;
SET @ijk = @ijk + 1;
END;
RETURN @result;
END;
CREATE OR ALTER PROCEDURE add_and_subtract(@a INT, @b INT, @x INT OUT, @y INT OUT) AS
BEGIN
SET @x = @a + @b;
SET @y = @a - @b;
END;
USE testdb;
SELECT * FROM animals;
SELECT count(*) FROM animals;
SELECT count(*) FROM animals WHERE id!=1;
SELECT dbo.factorial(2);
SELECT dbo.factorial(3);
SELECT dbo.factorial(4);
DECLARE @a INT = 12;
DECLARE @b INT = 5;
DECLARE @x INT;
DECLARE @y INT;
PRINT 'a = ' + CONVERT(VARCHAR(6), @a);
PRINT 'b = ' + CONVERT(VARCHAR(6), @b);
EXECUTE dbo.add_and_subtract @a, @b, @x OUT, @y OUT;
PRINT 'x = ' + CONVERT(VARCHAR(6), @x);
PRINT 'y = ' + CONVERT(VARCHAR(6), @y);
%JAVA_HOME% variable (must exist "%JAVA_HOME%\bin\java.exe")mvn.cmd locates) to the OS environment %PATH% variableThe subdirectory java-maven contains prepared Windows batches:
01-build.cmd - cleans, compiles and builds the Maven project02-run.cmd - runs the built Java archive (JAR)03-clean.cmd - cleans the Maven projectgradle.bat locates) to the OS environment %PATH% variableThe subdirectory java-gradle contains prepared Windows batches:
01-build.cmd - cleans, compiles and builds the Gradle project02-run.cmd - runs the built Java archive (JAR)03-clean.cmd - cleans the Gradle projectcsc.exe .NET C# compiler that is the part of Microsoft .NET Framework (part of OS)The subdirectory csharp contains prepared Windows batches:
01-compile.cmd - compiles the source code (contains the path definition to the csc.exe compiler)02-run.cmd - runs the Windows executable03-clean.cmd - deletes the Windows executable%PHP_HOME% variable (must exist "%PHP_HOME%\php.exe")php_pdo_sqlsrv_74_nts_x64.dll from Microsoft Drivers for PHP for SQL Server to the PHP directory %PHP_HOME%To the php.ini in the PHP directory %PHP_HOME% add lines
[PHP]
extension_dir = "ext"
extension=php_pdo_sqlsrv_74_nts_x64.dll
[Date]
date.timezone = Europe/Prague
The subdirectory php contains prepared Windows batch:
01-run.cmd - runs the code through the PHP interpreterNow in August 2020 I have the computer with Windows 10 Pro 64bit, 12GB RAM and available 50GB free HDD space
| Tool | Version | Setting |
|---|---|---|
| GIT | 2.26.0.windows.1 | |
| docker desktop | 2.3.0.4 (46911) stable | 2 CPUs, 3GB memory, 1GB swap, 48GB disc image size |
| Microsoft SQL Server image | 2017-CU8-ubuntu (14.00.3029) | password for sa: Syst3mAdm1n! |
| Microsoft SQL Server Management Studio | 18.6 | |
| Java JDK | 14.0.1 | Java(TM) SE Runtime Environment (build 14.0.1+7) |
| Apache Maven | 3.6.3 | |
| Gradle Build Tool | 6.3 | |
| PHP | 7.4.4 | 7.4.4-nts-Win32-vc15-x64 |
| Microsoft ODBC Driver | 17.06.0001 | msodbcsql64.msi, msodbcsql17.dll (version 03.80) |
| Microsoft Drivers for PHP for SQL Server | 5.8 (5.8.0+12928) | SQLSRV58.exe |
petrfaltus /
Console applications for JSON communication with my public available mortgage calculation REST service. Complete example collection. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework, for PHP and for Python.
34/100 healthConsole applications for JSON communication with my public available bank account validator and converter REST service. Complete example collection. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework, for PHP and for Python.
34/100 healthConsole applications for JSON communication with my public available state, territory, continent and area code REST service. Complete example collection. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework, for PHP and for Python.
34/100 healthpetrfaltus /
Console applications for connection to the MySQL, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.
31/100 health