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

  • Sagar Shinde

    Export SQL Result To A Text File

    This article gives an overview of how to export SQL query results to a text file.
    Sagar Shinde Dec 18, 2017
  • Manish Pandey

    SQL QUERY With CONVERT And VARCHAR

    Email Address is truncated with the use Convert and Varchar.
    Manish Pandey Dec 13, 2017
  • Andrew Jackson

    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.
    Andrew Jackson Dec 12, 2017
  • Nakul Chaudhari

    Remove Duplicate Rows In SQL Server Using CTE

    In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
    Nakul Chaudhari Dec 11, 2017
  • Pramod Thakur

    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.
    Pramod Thakur Dec 09, 2017
  • Sundaram Subramanian

    Roles And Responsibilities Of SQL Developer

    In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Nikunj Satasiya

    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.
    Nikunj Satasiya Dec 08, 2017
  • Bhuvanesh Mohankumar

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

    SQL Server 2017 - Check The Advanced Analytics Status

    Check the Advanced Analytics status using SERVERPROPERTY In SQL Server 2017/2016
  • 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 If The Server Is In Single-User Mode

    SQL Server: Check if the Server is in single-user mode using ServerProperty
  • Mohamed Elqassas Mvp

    SQL Server - Get The Collation Details

    SQL Server: Get the Collation Details using SERVERPROPERTY
  • Mohamed Elqassas Mvp

    SQL Server - Get The Default Path Of Data And Log Files

    SQL Server: Get the default path of data and log files via SERVERPROPERTY
  • Mohamed Elqassas Mvp

    SQL Server - Get the Installed Product Edition

    In this blog, we will see how to Get the installed product edition using "SERVERPTOPERTY".
  • 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 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 Integrated Security Mode

    Check the integrated security mode 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 27, 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 27, 2017
  • 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
  • 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
  • Manoj Kalla

    How To Create A Stored Procedure In SQL Server Management Studio

    In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store proc...
    Manoj Kalla 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".
  • Muhammad Zunair

    Introduction To SSIS

    SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Da...
    Muhammad Zunair Nov 24, 2017