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

  • Sundaram Subramanian

    Zero To Hero In MS SQL Server - Part Six

    In this article, I have shared some knowledge on WHERE CLAUSE and Update SQL Statement.
  • Jitendra Waghale

    String Function In SQL

    In this post, we will discuss how to work with SQL string functions and explain the concepts with an example in simple way. I hope this is very useful for beginners and intermediate to help them un...
    Jitendra Waghale Sep 17, 2018
  • Jitendra Waghale

    Joins In SQL

    In this post, we will discuss how to work with join's and explain the concepts with an example in simple way. I hope this is very useful for beginners and intermediate to help them understand t...
    Jitendra Waghale Sep 17, 2018
  • Jitendra Waghale

    SQL Table Constraints In Database

    In this post, we will discuss how to work with SQL constraints and explain the concepts with an example in simple way. I hope this is very useful for beginners to help them understand the basic con...
    Jitendra Waghale Sep 17, 2018
  • John Morehouse

    Steps For SQL DB Geo Replication

    If you are using SQL DB in Azure and don’t have your critical database geo-replicated, you are opening yourself up to potential issues in the event of a disaster. By configuring geo-replication you...
    John Morehouse Sep 15, 2018
  • Rupesh Kahane

    Bulk Insert, Update XML Data Into SQL Table

    In this article, I have created a sample XML format. Using nodes() method to shred XML into multiple rows, which propagates parts of XML documents into row sets.
    Rupesh Kahane Sep 15, 2018
  • Pradeep Kumar Gupta

    Find Primary/Unique/Foreign Keys And Delete Them In SQL

    Today, we will learn how to find the Primary/Unique/Foreign Keys in a table by using a simple SQL query, and delete these.
  • Rohit Kainth

    Merging Different Row Cells Into One

    This article is about merging different row cells into one for the purpose of reporting. Sometimes we need to customize according to the client’s requirements.
    Rohit Kainth Sep 12, 2018
  • Amey Vartak

    Setting Up SQL Data Sync

    In this article, we will be creating a hybrid sync group that contains both Azure SQL database & SQL Server Instance.
    Amey Vartak Sep 11, 2018
  • Rohit Kainth

    Updating Dynamic Columns On The Go

    I hope you all are doing fine. This particular article is about updating the dynamic columns on the go.
    Rohit Kainth Sep 11, 2018
  • Sanwar Ranwa

    T/SQL - Part Two

    In this article, we Learn about Cursor, types of Cursor in details with example.
    Sanwar Ranwa Sep 11, 2018
  • Sanwar Ranwa

    T/SQL Part - One

    In this Article, we will learn about T/SQL and difference between SQL and T/SQL.
    Sanwar Ranwa Sep 11, 2018
  • Sanwar Ranwa

    Joins In SQL Server

    Joins are used to Fetch data from two or more than two tables based on some conditions. Joins is one of the most important concepts of SQL Server. We can retrieve Data from multiple Table using Joi...
    Sanwar Ranwa Sep 10, 2018
  • Jitendra Waghale

    Triggers In SQL Server

    In this blog, you will learn about Triggers in SQL Server and I will explain the concept of triggers with an example in a simple way.
    Jitendra Waghale Sep 10, 2018
  • Riya Joshi

    SQL Server Management Studio 17.9 Released

    Microsoft recently announced the release of SQL Server Management Studio (SSMS) 17.9. The new release support of almost all the additions and enhancements from 2008 to 2017 versions of SQL Server.
    Riya Joshi Sep 10, 2018
  • Joel Champagne

    Using Materialized Views Effectively

    In this article, I will explain some of the rationale for material view usage along with a specific example that takes advantage of the SQL MERGE statement to incrementally reconcile changes to a t...
    Joel Champagne Sep 06, 2018
  • Pradeep Kumar Gupta

    Tabular Function To Split A Delimiter-Separated String To Rows With Their Position

    Split and convert a delimited string to a table with their position in SQL Server. The string contains words separated (delimited) by comma will be split into Table values.
  • Vishal Pawar

    Analyzing The Size Of Database And Size Of Table

    Analyzing The Size Of Database And Size Of Table. In this article, I am going to explain two SQL queries to find the size of the database and size of a table.
    Vishal Pawar Sep 06, 2018
  • Vishal Pawar

    ALL In One DataBase Hero Script - Set One

    This section covers most of the essential SQL Server scripts of DBA which we can use on a daily basis in the development of any BI project. CREATE DATABASE, CREATE SCHEMA, create table, ALTER DATAB...
    Vishal Pawar Sep 06, 2018
  • Vishal Pawar

    All About Primary Key And Its Basics

    All About Primary Key And Its Basics. In this article, we will learn about general SQL queries and their functioning.
    Vishal Pawar Sep 06, 2018
  • Sanwar Ranwa

    Operators In SQL Server

    An operator is a symbol which is used to perform some actions on the given expressions.
    Sanwar Ranwa Sep 05, 2018
  • Monica Rathbun

    Backup Encryption In SQL Server

    Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we are encrypting correctly. But some of us forget to take it a step farth...
    Monica Rathbun Sep 05, 2018
  • Dipendra Singh Shekhawat

    Ten SQL Server Shortcuts You Must Know

    In this article, I have listed shortcuts that I usually find helpful while working with SQL Server Management Studio.
  • Rohatash Kumar

    Select Query Using Like Clause in SQL Server 2012

    In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.
    Rohatash Kumar Sep 05, 2018
  • Sanwar Ranwa

    Data Integrity In SQL Server

    Data Integrity is used to maintain Accuracy and consistency of data in the Table.
    Sanwar Ranwa Sep 04, 2018