SQL Articles

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Articles

Uses of Merge Statement in SQL Server

This article explains the Merge Statement in SQL Server.
Shaili Dashora Feb 16, 2015
Service Broker in SQL Server

The SQL Server Service Broker helps developers to build scalable as well as secure database applications.
Jignesh Trivedi Jan 22, 2013
Encrypt and Decrypt in SQL Server: Part 5

In this article, we will create a symmetric key and encrypt and decrypt string using this key.
Akshay Patel May 16, 2013
Encrypt and Decrypt in SQL Server: Part 4

In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.
Akshay Patel May 14, 2013
Encrypt and Decrypt in SQL Server: Part 3

In this article, we will generate a certificate and using this certificate we will encrypt and decrypt the string.
Akshay Patel May 12, 2013
Encrypt and Decrypt in SQL Server: Part 2

In this article, we will discuss Database Master Key. The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database.
Akshay Patel May 08, 2013
Concept of Join in SQL Server

In this article we are show different types of joins in SQL Server. A Join in SQL is used to combine two or more tables. We use the Join operator to gather the data in a single query.
Arun Choudhary Mar 13, 2012
Clustered Vs Non-Clustered Index

In this article, you will learn about Clustered vs Non-clustered Index.
Kirtesh Shah Apr 06, 2021
Unlock the Secrets of the Rank Function in SQL Server

Unlock the power of SQL Server and learn the essential rank functions to optimize your database. Get tips and tricks you can use immediately to maximize your SQL Server performance!
Rakesh Kalluri Apr 10, 2015
Getting Date and Time Parts From DateTime in SQL Server

In this article, I would like to show the functions Datepart, DateName, Year, Month and Day in SQL Server.
Rohatash Kumar Apr 15, 2013
Difference Between Grouping and Grouping_ID in SQL

In this article, you will learn the difference between Grouping and Grouping_ID in SQL Server.
Rakesh Kalluri Jul 31, 2015
How to Use the EXCEPT and INTERSECT Operators in SQL Server

This sample shows how to use EXCEPT and INTERSECT operators in SQL Server 2005.
Raj Kumar Sep 28, 2008
Import Data From Excel to SQL Server (SSIS)

This article shows a simple procedure for importing data from Excel to SQL using SQL Server Integration Services (SSIS).
Abhishek Jaiswal Aug 19, 2014
SQL For Beginners - Introduction

This article will help you to learn SQL from scratch.
Jainish Shah Jan 04, 2016
Create a SQL Server CE Database From SQL Schema File

In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.
John Charles Olamendy Mar 04, 2009
Find and Delete Duplicate Records From SQL Table

In this article I explain how to count and delete duplicate records from SQL database table.
Sharad Gupta Apr 30, 2013
Use Of Table-Valued Parameter In SQL Server

Learn what is a Table Valued Parameter in SQL Server and how to create and use table valued parameters in stored procedures and queries.
Jignesh Trivedi Jul 23, 2012
Unlock the Power of Change Data Capture (CDC) in SQL Server

CDC is capture insert, update and delete activity on SQL tables.
Jignesh Trivedi Feb 21, 2012
SQL SELECT - GROUP BY Statement

In this article, you will learn how to use a SQL SELECT-GROUP BY statement in SQL.
Naresh Beniwal Oct 14, 2019
How To Find A Doctor Near Your Home in SQL Server

How to use a database to find nearby locations. The geography data type and associated SQL Server functions can be used to calculate distances and search for nearby locations.
Andrew Fenster Jun 07, 2013

261 - 280 of 398

CSS