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

How to Create Database in SQL Server 2019

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

Connect SQL Server with Visual Studio 2019

Hello Programmers, here is the article to connect SQL server with visual studio. Microsoft visual studio has nice facility where you can easily connect any database with visual studio. this article i am using SQL Server 2019 and Visual Studio 2019.Let’s see the all important steps to connect VS with ssms. 1.Click “Tools” Tab and […]

Migrate Oracle Tables to SQL Server

Hi Programmer,Here is the article to migrate oracle database tables into Microsoft SQL server.First we need to download and install ssma from Microsoft sites. To copy oracle database tables into Microsoft SQL server. let’s follow some steps. 1.Click File Tab next click “New Project” Give meaningful Project Name, suitable location and choose you SQL server […]

How to write SQL query in Visual Studio

How to execute SQL query in Visual Studio 2019.Hi Guy’s here are the steps to writes SQL server query in visual studio . Let’s follow the steps.step 1 : click Tools tab, click SQL Server –> New Query. step 2 : select Local. select any available server. note SSMS must be installed. automatically Server Name […]

Connect SQL Server with Visual Studio Code

Hello Friends, in this article , i m going to explain all steps to connect sql server with visual studio code. Step 1 : Open visual studio code, click extensions. write in search box SQL server and click install. Step 2 : After installing SQL Server(mssql) click View Tab and select Command Palette and click. […]

Connect Sybase with Oracle SQL Developer

using SQL Developer to connect Sybase databases. step 1 : open Oracle SQL Developer . click Tools Tab Next click Preferences. step 2 : inside preferences select Database. step 3 : inside Database “Third Party JDBC Drivers step 4 : inside “Third Party JDBC Drivers” click Add Entry. now you have to give jdbc driver. […]

Connect SQL Server with Oracle SQL Developer

Using SQL Server Database connecting Oracle SQL developer. step 1 : open Oracle SQL Developer . click Tools Tab Next click Preferences. step 2 : inside preferences select Database. step 3 : inside Database “Third Party JDBC Drivers step 4 : inside “Third Party JDBC Drivers” click Add Entry. now you have to give jdbc […]