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.


  • Mohamed Elqassas Mvp

    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.
  • Mohamed Elqassas Mvp

    SQL Server - Check The Integrated Security Mode

    Check the integrated security mode using SERVERPROPERTY in SQL Server
  • Mohamed Elqassas Mvp

    SQL Server - Check If Always On Availability Of Groups Is Enabled Or Disabled

    Let's learn how to check if the "Always On" Availability of Groups is enabled or disabled using SERVERPROPERTY in SQL Server.
  • Mohamed Elqassas Mvp

    SQL Server - Check The "Always On" Availability Group Manager's Status

    Check the "Always On" availability groups manager status using SERVERPROPERTY in SQL Server.
  • Mohamed Elqassas Mvp

    SQL Server - Check If The Full-Text And Semantic Indexing Components Are Installed Or Not

    Check if the full-text and semantic indexing components are installed or not using SERVERPROPERTY In SQL Server
  • Shamim Uddin

    Updating A Table Using Join In SQL Server

    Today, we will learn how to update a Table using Join In SQL Server.
    Shamim Uddin Nov 26, 2017
  • Sagar Shinde

    Append A Value To The Existing Value In SQL Server

    This blog will help users update a record while keeping the existing record value if it exists.
    Sagar Shinde Nov 26, 2017
  • Purvi Pandya

    Count Number Of Rows In Table Within A Milisecond

    Count the number of rows in table within a milisecond with more than 28 lakh records.
    Purvi Pandya Nov 25, 2017
  • Mohamed Elqassas Mvp

    SQL Server - Get The Computer Name On Which The SQL Server Instance Is Running

    Get the computer name on which the SQL server instance is running via "ServerProperty"
  • Mohamed Elqassas Mvp

    SQL Server - Get The Full SQL Server Instance Name

    Get the full SQL Server instance name via "ServerProperty". In this blog, we will simply show How to Get the full SQL Server Instance Name using "SERVERPTOPERTY".
  • Dharmraj Thakur

    Group By Vs Distinct Difference In SQL Server

    Difference between GROUP BY clause and DISTINCT in sql server. When and where to use GROUP BY and DISTINCT.
    Dharmraj Thakur Nov 17, 2017
  • Suvendu Shekhar Giri

    Transact SQL Code Snippets

    A Transact-SQL code snippet is a template containing the basic structure of a Transact-SQL statement or block. You can use snippets as a starting point when adding statements in the Database Engine...
  • Sagar Shinde

    Computed Columns In SQL Server

    This article will help the user to write a complex calculation in the backend (SQL SERVER). A computed column is computed from an expression that can use other columns in the same table.
    Sagar Shinde Nov 07, 2017
  • Morteza Mousavi

    SQL UNION Operator

    The SQL UNION operator combines two or more SELECT statements.
    Morteza Mousavi Oct 13, 2017
  • Nikunj Satasiya

    Write And Execute Dynamic SQL Query In SQL Server

    This example demonstrates how to write and execute dynamic SQL Query in SQL Server. You can execute the Query using EXEC sql command and sp_executesql commands in SQL Server.
    Nikunj Satasiya Sep 28, 2017
  • Talaviya Bhavdip

    How To Find Which Table Record Count Increases Or Decreases In SQL Server

    In this blog, the user can find out in which table records are deleted or inserted.
    Talaviya Bhavdip Sep 26, 2017
  • Hamid Khan

    ACID Properties In SQL

    ACID properties are atomicity, consistency, isolation, and durability.
    Hamid Khan Sep 18, 2017
  • Saravanan Ponnusamy

    Different Ways To Use GETDATE() Function In SQL Server 2008 R2

    This blog will list different ways to use GETDATE() funtion in SQL Server 2008 R2. The major changes in the new SQL Server 2008 are the DateTime function and the introduction of new data types.
  • Anil Avula

    SQL Server Setup Or Installation Failure Errors

    SQL Server 2008 R2 setup failed with “Error 1406. Could not write value to key \SOFTWARE. System error. Verify that you have sufficient access to that key, or contact your support personnel”.
    Anil Avula Sep 06, 2017
  • Nisarg Upadhyay

    Parameter Sniffing In SQL Server

    SQL Server uses a process called parameter sniffing when it executes a stored procedure that has parameters. When the procedure is compile or recompiled, the value passed in the parameter is evalua...
    Nisarg Upadhyay Aug 23, 2017