What is SQL Primary Key
What is SQL primary key? A SQL primary key is a column that uniquely identifies each row in a table. Primary key can be created …
Category: SQL
Import Excel Data in SQL Server
In this section you will know how to import Excel data in SQL server. This is the manual way to import Excel data in SQL …
SQL Management Studio – Overview
Let try to understand different area of SQL server Management Studio window. as shown below screenshot the numbering and each numbers are explained in the …
Connect with SQL Server using Management Studio
Most of beginner think, how can we connect with SQL server, after installation of SQL server and SQL server management studio instant on local machine. …
SQL Server Management Studio Installation
Steps wise instruction with screenshot how to install SQL Server with Management Studio (SSMS) to interact with SQL server instance. The SQL Server Management Studio …
SQL Server Installation
This section will show you step by step learning, how to install the SQL Server 2019 Developer Edition. Install SQL Server 2019 Developer Edition To …
What is SQL server – Definition and Architecture
SQL Server is a relational database management system, or RDBMS, developed by Microsoft. SQL Server is built on SQL, a standard programming language for interacting …
SQL DISTINCT Query
Overview: In This tutorial you will learn and understand how to use SQL DISTINCT query with examples. The DISTINCT SQL query is used to return …
SELECT TOP in SQL
In this tutorial you will learn and understand SELECT TOP query in SQL with practical examples. This SELECT TOP query will help you to get …
SQL Foreign key
Overview: In this Tutorial You will understand what is SQL FOREIGN KEY, Use of Foreign Key. A FOREIGN KEY is a field in first table …