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.

RECENT POSTS

  • How Should We Store Images And Blob Files In SQL Server

    Storing images in a SQL Server database is a common task. Binary Large Objects also know as BLOBs, are lager data files such as images and sounds. In this article, you'll learn how to store images
  • How To Check A Particular Column Of A Table Update Using COLUMNS_UPDATED() In SQL Server

    In this blog, we will learn how to check if a particular column of a table is updated or not. If the column updates, the current record inserts into a trigger table using the trigger.
  • Enable Mail Profile Back To Basics

    I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to realize it’s not working. The reason in the cases I’ve seen is because they have simpl
  • How Your Hypervisor Can Impact Your CPU

    The most prevalent SQL Server wait type was SOS_SCHEDULER_YIELD. This wait type is typically prevalent on a server undergoing CPU pressure.
  • Indexes in SQL Server

    This article describes indexes in SQL Server. Indexes are used in relational databases to quickly retrieve the data.
  • What Is Accelerated Database Recovery In Azure

    Microsoft recently announced the preview of Accelerated Database Recovery? ADR is a redesigned SQL database engine feature that improves database recovery process in Azure in the presence of long runn
  • Cursors In SQL

    This article explains what cursors are in SQL Server and how to use Cursors in SQL with examples. A SQL cursor is a temporary work area created in system memory when a SQL statement is executed.
  • Knowing The Options

    In this article, we will take a look at the built-in @@Options function that will show you what options are enabled on your local SQL Server Management Studio client.
  • Common Table Expression (CTE) In SQL Server

    According to the CTE documentation, Common Table Expression is a temporary result set or a table in which we can do CREATE, UPDATE, DELETE but only within that scope. That is, if we create the CTE in
  • Most Asked SQL Queries In Interviews

    Do you wonder what the most frequently asked SQL queries are in interviews? Here is a list of most asked SQL queries in interviews.
  • Exception Handling in SQL Server

    In this article you will learn about Exception Handling in SQL Server.
  • Convert Comma Separated Values To Rows And Vice Versa Using In-built And Custom SQL Code

    This blog explains the process of how to convert CSV values into row values and vice-versa, using in-built and custom SQL queries.
  • 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.