Update, get the one with localdb
SQL Server Express LocalDB – SQL Server | Microsoft Learn
Then get SSMS
Then you can connect:
Choose master on options
Download MS SQL Server 2016 Express:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840
Install also the SSMS tool from the install, or download it from MS.
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.
Use SSMS to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud.
SSMS is free!
Connect: .\SQLEXPRESS or the below
Create a autoincrement, Make sure that the Key column’s datatype is int and then setting identity manually
Make some field and go to file->save Table_1, give it a name
Primary key, click and set:
Refresh with F5
–select * from dbo.Hello_Table
–insert into dbo.Hello_Table (h_name, h_topic) values (‘test2’, ‘hello’);
The result with autoincrement, nice.
pyodbc
https://datatofish.com/how-to-connect-python-to-sql-server-using-pyodbc/
WideWorldImporters (WWI) is a sample database that showcases database design using current features, tools and design techniques. WideWorldImporters downloads include an OLTP and an OLAP database which are built to run on SQL Server 2016 and later.
https://docs.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver15