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.


  • SQL Server - Invalid Column Name ‘ABC’ Error While Accessing Newly Added Column

    In this blog, we will look into steps to be followed for fixing invalid column name ‘ABC’ Error while accessing a newly-added column.
  • Introduction To SQL Server Pagination

    In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
  • Stored Procedures Vs User Defined Functions And Choosing Which One To Use

    In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply funct...
  • Comparison Of Subquery And Joins

    Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Why Dynamic Query Is Bad

    In this article, we will be talking about Dynamic Query and why it is bad.
  • Understanding SQL Server Transparent Data Encryption

    In this video, we will look into the encryption of SQL Server Database using TDE.
  • Why SELECT Is Called DML

    The word “Manipulation” means to play with the data, not only retrieve or fetch the data. We can include retrieve, store, modify, delete, insert, update and copy operations in DML.
  • How To Backup All Databases In SQL Server

    When we have more databases on a Server to backup, it is very time-consuming to backup all databases manually. In such cases, we can use T-SQL to automate these tasks. We can use SQL Server Managem...
  • Difference Between Primary key, Unique key And Foreign Key

    In this blog we will learn the basic differences between Primary key, Unique key and Foreign key.
  • Introduction To SQL Server Dynamic Data Masking

    In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
  • Store And Retrieve Using FILESTREAM From SQL Database

    Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my p...
  • Look At SQL Server Encryption - Part I

    In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.
  • FILESTREAM Feature In SQL Server

    Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Remove Duplicate Records From A Table In SQL Server

    In this blog i am going to explain how to remove duplicate records from a table in SQL Server.
  • Using CASE Statements In A SQL UPDATE Query

    I have SQL server Table in which there is column that I wanted to update according to a 2 columns value that are present in current row. In this scenario, we can use CASE expression. CASE expressio...
  • Export SQL Result To A Text File

    This article gives an overview of how to export SQL query results to a text file.

    Email Address is truncated with the use Convert and Varchar.
  • Transfer Database From SQL Server 2008 To 2014

    Transfer database from SQL Server 2008 to 2014 using different migration techniques with the help of this article.
  • Remove Duplicate Rows In SQL Server Using CTE

    In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
  • Ways Of Finding Foreign Key In SQL Server

    In this blog, we are trying to find in how many ways, we can find foreign key in SQL Server.
  • Roles And Responsibilities Of SQL Developer

    In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • How To Pass Output Parameter To Stored Procedure In SQL Server

    In this tutorial, I will explain how to pass the output parameter to a stored procedure in MS SQL Server.
  • Audit Made Easy Without Audit Log - Part One

    In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • SQL Server 2017 - Check The Advanced Analytics Status

    Check the Advanced Analytics status using SERVERPROPERTY In SQL Server 2017/2016
  • SQL Server - Check If The Failover Cluster Is Configured Or Not

    Check if the failover cluster is configured or not using SERVERPROPERTY In SQL Server.
  • View More