Azure

Azure Knowledge Studio – Create, Question And Delete In SQL Server

On this Azure Knowledge Studio Sequence article, we’ve discovered concerning the fundamentals of Azure Knowledge Studio and how one can set up it, went via a step-by-step information to attach Azure Knowledge Studio to Azure SQL Database, learnt to attach and question to Azure SQL Database. Following the final article, this text dives in connecting and thus creating tables, working with queries and deleting the information in SQL Server from Azure Knowledge Studio.

Azure Knowledge Studio Article Sequence

  1. Azure Knowledge Studio
  2. Azure Knowledge Studio – Connecting To Azure SQL Database
  3. Azure Knowledge Studio – Create, Question and Delete in Azure SQL Database
  4. Azure Knowledge Studio – Create, Question And Delete In SQL Server

Azure Knowledge Studio

Azure Knowledge Studio is mainly a database software that’s cross-platform routinely utilized by knowledge engineers and professionals for each on-premises and cloud companies all through the working system spectrum from Home windows to macOS and Linux. There are quite a few trendy editor choices with the Azure Knowledge Studio from Code Snippets, IntelliSense, Built-in Terminal, Supply Management Integration, and extra. An amazing expertise with charting of question outcomes, customizable dashboards are supported built-in.

Now, allow us to be taught to attach and question in our SQL Server utilizing Azure Knowledge Studio.

To start with, we have to begin with the Set up of SQL Server. Allow us to be taught to obtain and set up within the SQL Server. The Developer Version SQL Server 2019 is freely obtainable. Obtain it by following the article, SQL Server 2019 – Obtain and Set up.

As soon as we’ve got setup our Azure Knowledge Studio and SQL Server, we will go forward.

Step 1

Open Azure Knowledge Studio. We’ll be taken to Welcome Web page like the next. 

Click on on New.

Step 2

Choose New Connection beneath New button.  A connection web page will pop up.

Step 3

Fill within the particulars for the reference to Connection Sort as Microsoft SQL Server, Server as localhost and Database as grasp. Put in username and password as you’ve gotten setup if requested.

As soon as these particulars are crammed in, click on on Join.

Step 4

Now, the SQL Server 2019 is related to our Azure Knowledge Studio. We will see on the prime, the grasp database from the localhost server.

Now, Click on on New Question.

Step 5

A New SQL Question web page has now been opened. We will kind in our question right here.

Creating Database

Step 6

Right here, we choose the grasp database and beneath it, with the next SQL code within the Question Editor, we create a brand new database TutorialDB.

USE grasp
GO
IF NOT EXISTS (
 SELECT title
 FROM sys.databases
 WHERE title = N'TutorialDB'
)
 CREATE DATABASE [TutorialDB];
GO
IF SERVERPROPERTY('ProductVersion') > '12'
 ALTER DATABASE [TutorialDB] SET QUERY_STORE=ON;
GO

Click on on Run to Execute the Code.

Step 7

Proper click on on localhost server and click on on Refresh to see the replace in Database.

We will see, a brand new database TutorialDB has now been created efficiently. All of the executed queries are additionally up to date within the message part.

Creating Desk

Step 8

To start with, change the database setting to TutorialDB.

Now, with the next code, we create a brand new Desk named Prospects with the Columns CustomerId, Identify, Location, E-mail with the CustomerId set because the Main Key.

-- Create a brand new desk referred to as 'Prospects' in schema 'dbo'
-- Drop the desk if it already exists
IF OBJECT_ID('dbo.Prospects', 'U') IS NOT NULL
 DROP TABLE dbo.Prospects;
GO
-- Create the desk within the specified schema
CREATE TABLE dbo.Prospects
(
 CustomerId int NOT NULL PRIMARY KEY, -- major key column
 Identify nvarchar(50) NOT NULL,
 Location nvarchar(50) NOT NULL,
 E-mail nvarchar(50) NOT NULL
);
GO

Now, we will see, the desk has now been created.

Inserting Row in Desk

Step 9

With the next code, we add in values comparable to Ram, Nepal and so forth to the respective columns of CustomerId, Identify, Location and E-mail.

-- Insert rows into desk 'Prospects'
INSERT INTO dbo.Prospects
 ([CustomerId], [Name], [Location], [Email])
VALUES
 ( 1, N'Ram', N'Nepal', N'ram@hotmail.com'),
 ( 2, N'Sita', N'United States', N'sita@charpcorner.com'),
 ( 3, N'Hari', N'Nepal', N'hari@gmail.com'),
 ( 4, N'Geeta', N'India', N'geeta@hotmail.com'),
 ( 5, N'Chiu', N'Indonesia', N'chiu@hotmail.com')
GO

Click on on Run to execute the question.

Displaying Knowledge in Desk

Step 10

With the next code, we choose the rows from the desk and them view the information.

-- Choose rows from desk 'Prospects'
SELECT * FROM dbo.Prospects;

We will see, all the information we inputted priorly with names, location and e mail of 5 totally different Prospects.

Deleting Knowledge from Desk

Step 11

-- Delete rows from desk 'Prospects'
DELETE FROM dbo.Prospects;

We use the next question to delete the rows from the desk thus deleting all the information.

As soon as, we Click on on Run. The information are deleted.

To Verify if the information remains to be up there within the desk or not, use the Displaying Knowledge question and also you’ll acquire the end result.

Thus, we will see, all of the rows have now been.

Conclusion

Therefore, we discovered from this text to attach Azure Knowledge Studio to SQL Server. Subsequent, we discovered to create database, create desk and insert, question and delete knowledge within the database.

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button