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. […]

Subquery in SQL Server | Types of Subquery

Hi Programmers,welcome to new article of ozanecare. this article i’ll write the queries for subquery in Microsoft SQL Server. SUB-QUERIES : If we write select statement in where Clause that can be called it as sub queries or inner queries.Four Types of SUB-QUERIES.1.Single ROW SUB-QUERIES2.Multi ROW SUB-QUERIES3.Multiple Column SUB-QUERIES4.Correlated SUB-QUERIES , Let’s see the queries. […]

Correlated Subquery in SQL Server

Hi Programmers,welcome to new article of ozanecare. this article i’ll write the queries for correlated subquery using Microsoft sql server. The correlated subquery is a sub-query that uses values from the outer query. In this case the inner query has to be executed for every row of outer query andsubquery depends on the outer query […]

Find Cumulative Salary of an Employee in SQL Server

Hi Programmers, welcome to ozanecare software blogs. this article is about to give different queries to calculate cumulative salary of employee using Microsoft SQL server. Let’s see the Queries. 1.All the Records of Emp Table. See below image. 2. Calculate cumulative salary with the help of sum aggregate function. OVER clause and order by clause. […]

How to Drop Database in SQL Server

Hi Developers , Welcome to the Ozanecare. In this article I’ll explain all important steps to drop database in Microsoft SQL server 2019. Anything in SQL Server Management Studio (SSMS) , we can do by two ways. First –> Graphically , Second –> Queries. To Drop Database in SQL SERVER let’s follow steps. Step 1 […]

How to Alter Database in SQL Server

Hi Developers , Welcome to the Ozanecare. In this article I’ll explain all important steps to alter database in Microsoft SQL server 2019. Anything in SQL Server Management Studio (SSMS) , we can do by two ways. First –> Graphically , Second –> Queries. To Alter Database in SQL SERVER let’s follow steps. Step 1 […]