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

  • Vaidehi Pandere

    Cursors In SQL Server

    A SQL cursor is a database object that retrieves data from result sets one row at a time.The cursor in SQL can be used when the data needs to be updated row by row.
    Vaidehi Pandere Mar 12, 2020
  • Sai Prakash

    Cursor In SQL Server

    In this article you will learn about Cursors in SQL Server.
    Sai Prakash Mar 11, 2020
  • Dave Bland

    Max Degree Of Parallelism Vs Cost Threshold For Parallelism

    This post will cover the differences between Max Degree of Parallelism and Cost Threshold for Parallelism. These are two server settings that have a less the ideal default value. All DBAs should ...
    Dave Bland Mar 09, 2020
  • Rohatash Kumar

    Row_Number Function With PARTITION BY Clause In SQL Server

    SQL partition by. Learn how to use Row_Number function without Partition By in SQL or with Partition By in SQL. SQL Partition By Example.
    Rohatash Kumar Mar 09, 2020
  • Deepak Middha

    Triggers in SQL Server

    A SQL trigger is a database object just like a stored procedure or we can say it is a special kind of Stored Procedure that automatically fires when an event occurs in a database. Learn what is a t...
    Deepak Middha Mar 07, 2020
  • Jasminder Singh

    Row_Number in SQL Server

    This article explains the row_number function in SQL Server. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these...
    Jasminder Singh Mar 07, 2020
  • Manoj Kalla

    Create A Stored Procedure In SQL Server

    In this article, you will learn about how to create a stored procedure in SQL Server using SSMS.
    Manoj Kalla Mar 07, 2020
  • Jaipal Reddy

    Difference Between TRUNCATE, DELETE, And DROP In SQL Server

    In this blog, you will learn the difference between TRUNCATE, DELETE and DROP SQL commands.
    Jaipal Reddy Mar 07, 2020
  • Sanghdeep Sanghratne
  • Pankaj  Kumar Choudhary

    Pivot And Unpivot In SQL Server

    Learn learn how to use pivot and unpivot in SQL with code example.
  • Dave Bland

    DEADLOCK_PRIORITY: How is it Used?

    This post will go over how you can use the DEADLOCK_PRIORITY to prioritize your processes so that the most important ones aren't chosen as victims of a deadlock.
    Dave Bland Mar 06, 2020
  • Pankaj  Kumar Choudhary

    Cursors In SQL

    This article explains what cursors are in SQL Server and how to use Cursors in SQL with examples. A SQL cursor is a temporary work area created in system memory when a SQL statement is executed.
  • Anu V

    SQL Server - Union Vs. Union All

    Learn the difference between SQL Union and Union All. Code example Union vs Union All in SQL.
    Anu V Mar 05, 2020
  • Priyanka Singh

    Detailed Description Of Primary Key In SQL Server

    In this article, you will learn about a detailed description of the primary key in SQL server.
    Priyanka Singh Mar 05, 2020
  • Archit Shrivastava

    Apply a Single Script for Multiple Databases Using Database Name

    In this blog, I will explain to you how to apply a script or a query to multiple databases in a single execution using a database name.
    Archit Shrivastava Mar 04, 2020
  • Mahesh Chand

    Download And Install SQL Server Management Studio 18

    SQL Server Management Studio (SSMS) is a Windows client app that allows database developers and database administrators to configure and manage SQL Server and Azure SQL databases. Learn how to dow...
    Mahesh Chand Mar 04, 2020
  • Sanghdeep Sanghratne

    What is a Trigger? What are the Types Of Triggers? How to Display Information About Events - Part...

    In this article, you will learn about how to display information about events.
  • Dave Bland

    Find Failed Logins Using Extended Events

    This post will go very a few of the methods that can be used to capture failed logins to your SQL Servers.
    Dave Bland Mar 02, 2020
  • Mohit Chhabra

    Fixing Corrupted Databases

    I shared my personal experience on how can we fix corrupted databases using a third party product called stellar.
    Mohit Chhabra Feb 28, 2020
  • Monica Rathbun

    Being A Woman In The SQL Community

    In this article, you will learn about being a woman in the sql community.
    Monica Rathbun Feb 28, 2020
  • Dave Bland

    Dave Bland's SQL Server Blog

    This post will focus on how to find what logins are mapped to database user accounts in a SQL Server database.
    Dave Bland Feb 18, 2020
  • Gokulakrishna

    How to Create a PostgreSQL Server on Google Cloud Platform SQL Database Service

    In this article, you will learn how to create a PostgreSQL Server on the Google Cloud Platform SQL Database service.
    Gokulakrishna Feb 13, 2020
  • Monica Rathbun

    String Function In SQL Server

    In this article, you will learn about String Function in SQL Server.
    Monica Rathbun Feb 13, 2020
  • Lokesh Kumar

    Error 927 - Database Cannot Be Opened While Mirroring Configuration - SQL Server

    In this article, you will learn about Error 927: database can't be opened , it is middle of the restoration. it comes when we click on start mirroring. Actually this is not an error, this msg...
    Lokesh Kumar Feb 07, 2020
  • Monica Rathbun

    SQL Server In Memory Table Indexes

    In this article you will learn about SQL Server in memory table indexes.
    Monica Rathbun Feb 05, 2020