Freelance Project Requests info@CodeDocu.de 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
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
 
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.
     
    Developer
    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

-- sqlcmd -S DESKTOP-NMLTF46\SQLEXPRESS -E

--

 

select @@Version

go

------------------------------------------------------------------------------------

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)

1>


 
 

 
 
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
https://docs.microsoft.com/de-de/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
 

 
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

 
Mobile
SQL
»
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: raimund.popp@microsoft-programmierer.de