Create Tables and Insert Data in SQL Server

Hi programmers , welcome to another Microsoft SQL server post. this article i’ll write different query to create table and insert records in SQL server. The Create statement is used to create tables and insert statement is used to inserting data into database table. let’s see the queries. 1.Creating basic tables without using any constraints. […]

Install SQL Server 2019 on Windows 10 [2021]

Hi Programmers, welcome to new post Microsoft SQL Server 2019 version in Windows operating system.First we need to download SQL server 2019 . For installation , let’s follow the following steps.Step1. click setup file of SQL server 2019 –>installation –> click New SQL server stand-alone installation. see below image. Step2: Speify types of edition(Developer) –> […]

Install SQL Server Management Studio 18

Hi Programmers, welcome to new post Microsoft SQL Server Management Studio 18 version in Windows operating system.First we need to download SQL server 2019 and ssms 18.8(any latest version). For installation , let’s follow the following steps. Step1.click setup file of SQL server 2019 –>installation –> click New SQL server stand-alone installation. see below image. […]