In Focus
SQL Server
Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.


  • Encrypt And Decrypt Column Data In SQL Server

    Sometimes, we may want to encrypt a SQL Server column data, such as a credit card number. In this blog, let's learn how we can encrypt and decrypt SQL Server column data in the database itself.
  • SQL PASS Summit Registration is opened for 2019

    PASS Summit registration is OPEN and there is a $100 discount code (THANKS100*) burning a hole in your inbox.
  • Joins in SQL Server 2012

    In this article, I describe Joins, Inner Join, Outer Join, Cross Join, Self Join in SQL Server 2012.
  • Understanding Foreign Key Through GUI In SQL Server

    In this video tutorial, we will learn how we can create a Foreign Key in a child table referencing its parent table. And, we will try to understand the concept of foreign keys through GUI.
  • Brief Introduction To Indexes In SQL Server

    Here, I will be giving a brief introduction to Indexes in SQL Server and why we need the indexing.
  • About Views in SQL Server

    This article describes Views in SQL Server. This article explains What a View is, Types of Views in SQL Server, and how to create Views in SQL Server.
  • Use Of DISTINCT Keyword In T-SQL (SQL Server)

    In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.
  • Working With Cluster Logs

    The PowerShell cmdlet get-clusterlog is a quick and handy way to get the information from the Windows Cluster. This cmdlet will create a text log file for all the nodes or a specific node (if specifie
  • Backing Up And Restoring Database Without Using .bak File

    In this article, we will discuss how to backup and restore the database without using the .bak file in SQL Server.
  • SQL Query To Calculate Age Using Given Date Of Birth (DOB)

    Date of Birth can be used to calculate the age in years, months, and days.
  • Calling SQL Server With HTTP Webhooks

    In this article, I will introduce you to Enzo Onlineā€™s SQL Server webhook, a free service you can use to call a SQL Server database hosted in the cloud using HTTP commands so that you can easily progr
  • 5 Quick Ways To Delete Duplicate Records From Database Which Every Developer Must Know

    In this tutorial, I explain the 5 quick ways to delete duplicate records from any database table. These ways must be known to every developer.
  • Sub Queries In SQL Server

    In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.
  • Scheduling Things To Run In SQL Server

    A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule for each agent job, frequently with applications like Reporting Services, users use Shared Schedul
  • Temporary Tables Types In SQL

    This blog is about temporary tables in SQL, their types, and differences between them.
  • Improve SQL Query Performance

    In this blog, I will explain how to improve the performance of your SQL query. As a developer, we know any SQL query can be written in multiple ways but we should follow the best practices/techniques
  • Understanding SQL Server Yukon Service Broker

    The new version of Microsoft SQL Server Yukon comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Servi
  • Pros And Cons Of Money DataType

    In this article, I will list the Pros and Cons Of Money DataType in SQL Server. Money DataType vs Decimal DataType vs Float DataType.
  • How To Find Employees Hired Last Month Or Year In SQL Server

    In this blog, we will understand how we can find employees hired last month or year. We will understand DATEDIFF function in SQL server. The DATEDIFF function is used to calculate the difference betw
  • Different Types Of Clauses In SQL Server

    In this blog, we are going to learn about clauses in SQL Server. Clauses are used with table expressions and help in finding the result.
  • TRIM Function In SQL Server 2017

    TRIM() is a new function introduced in SQL Server 2017 which helps to remove the white space/characters from both sides of a string. Let us see all aspects of this function in detail.
  • A Deep Dive Into Joins In SQL

    In this article, we will go through a deep understanding of SQL Joins from scratch.
  • JOIN Tables Without Foreign Key In SQL Server

    In this blog, we will understand how to join two or more SQL tables without using a foreign key. We will also get an overview of Join and Keys in SQL.
  • ASCII Values Of Alphabets And Numbers In SQL Server

    In this blog, we will understand the usage of ASCII function in SQL Server and find ASCII values of capital and small alphabets.

    We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table. This process can generate a noticeable performance hit especially for larger tables with m
  • View More