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

  • Sachin Tripathi

    Union V/S Join In SQL

    In this blog, we will learn about the differences between Union and Joins in SQL. Union and Join, both are used to combine the data from two or more tables.
    Sachin Tripathi Sep 21, 2018
  • Yashwant Vishwakarma

    Installing SQL Server vNext On Linux - Part One

    Installing SQL Server vNext On Linux. install SQL Server vNext on Ubuntu, install SQL Server on Linux. install SQL Server vNext on Linux. install SQL Server vNext.
  • Vishal Pawar

    Identifying Relationship Between Columns In SQL

    Identifying relationship between columns in SQL. The query is given below to find the relation between any two columns in the given database. How to search the column in the database by its name.
    Vishal Pawar Sep 20, 2018
  • Jitendra Waghale

    Database Backup And Restore In SQL Server

    Backup and Restore are common functions of a database administrator. In this tutorial, you learn how to create a SQL Server database backup and restore it back using SQL Server tools.
    Jitendra Waghale Sep 19, 2018
  • Monica Rathbun

    Be Careful With Your SQL Server Max Memory Settings

    Quite often, I see database administrators set SQL Server Max Server Memory thinking that only everything related to SQL Server uses this shared memory pool. This is a mistake. There are many thing...
    Monica Rathbun Sep 19, 2018
  • Sanwar Ranwa

    T/SQL - Database Trigger - Part Four

    In this article, we will learn about Database Triggers in SQL Server. We also learned the concept of Magic Tables in SQL Server.
    Sanwar Ranwa Sep 18, 2018
  • Sanwar Ranwa

    T/SQL - Stored Procedures and Functions - Part Three

    In this Article we Learn about store procedures and User Defined Function in SQL Server with Example.In previous article,we discussed about T/SQL and Cursor.
    Sanwar Ranwa Sep 17, 2018
  • 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

    Views In SQL Server

    In this blog, we will discuss how to work with Views in SQL Server and explain concepts with an example in a simple way. I hope this is very useful for beginners to help them understand the basic c...
    Jitendra Waghale Sep 17, 2018
  • 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 K 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.
    Pradeep K Gupta Sep 14, 2018
  • Jitendra Waghale

    Overview Of Stored Procedure In SQL server

    In this blog, we will discuss how to work with Stored Procedure and explain the concept with an example in a simple way. I hope this is very useful for beginners and intermediate to help them under...
    Jitendra Waghale Sep 13, 2018
  • 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
  • View More