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 […]
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 […]
Hi Developers, Here i am going to explain all important steps to perform insert update delete in asp.net using c#.This article i am going to use List View Control to insert update delete records. Without Writing hard codes we canperform insert update delete. we should only proceed some wizards. Let see how to perform insert […]
Hello Developers, Here is Article to Create Login Form in ASP.NET with SQL Server. Here i am using Microsoft Visual Studio and Microsoft SQL server.First i am going to create registration form using SQL server.Let’s Follow some important steps. step 1 : Open Visual Studio.Go to File Tab –>Project –>Web –>ASP.NET Web Application –>Select Empty […]
Hello Programmers, here is the article to connect SQL server with ASP.NET. Microsoft ASP.NET has nice facility where you can easily connect any database with ASP.NET. this article i am using SQL Server 2019 and ASP.NET MVC.Let’s see the all important steps to connect asp.net with SSMS. 1.Click “Tools” Tab and next Click “Connect to […]
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 […]
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 […]
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. […]
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 […]