Sql

MS SQL Server 2016 Express with SSMS

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.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

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

Comments Off on MS SQL Server 2016 Express with SSMS