Freelance Project Requests Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net

Download SQL SErver Express Edition at: version 2017
There are 2 versions:
Express Edition
SQL Server 2017 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.
  • è For local developments or if you run a web server with a local database.
    SQL Server 2017 Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.
  • è If you have a Microsoft Developer Account (free) and need the database for testing or development.

Server=localhost\SQLEXPRESS;Database=master; Trusted_Connection=True;



-- run below commmand from command prompt




select @@Version



Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)

Aug 22 2017 17:04:49

Copyright (C) 2017 Microsoft Corporation

Express Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 17763: )



(1 lines affected)



Microsoft SQL Server  Management Studio
The SSMS Management Studio is an operating window for the Microsoft SQL SErver. Here you can manage the SQL Server and manage tables manually
Install Management Studio
From the website: Select English or German version

Start SQL Server Management Studio
After that you can start the Management Studio in the Windows Start Icon

Login in SQL Server Express
The SQL server of an MS SQL Server Express Edition is referred to as

Server name: .\SQLEXPRESS

Leg of a local machine, it is sufficient to use the current Windows login in Authentication.
Therefore, use the current user:

Authentication: Windows Authentication


Then you see the local SQL Server as an application

SQL Commands
Install SQL Server Express Edition and Start login
SQL Server Warning: Data loss could occur
SQL Server: Default default current time
Instr(..) in SQL Server
Access, SQL : Duplikate oder doppelte Ergebnisse ausblenden mit DISTINCT
Verschachtelte, komplexe Abfragen mit Detailfeldern erweitern
Verschachteln von komplexen Abfragen
SELECT Abfrage als geschlossenes neues Datenset, Tabelle ausgeben
Kapseln eines SQL-Ergebnisses / Werte-Tabelle in einer neuen Tabelle


Contact for Jobs, Project Requests: