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.

Blogs

  • 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
  • Sagar Jaybhay

    The SQL Select Statement

    This blog explains the Select statement in SQL.
    Sagar Jaybhay Jan 28, 2020
  • Salman Beg

    Collate Clause in SQL Server

    In this blog, I will discuss the collate clause and also discuss how the expression type 'int' is invalid for collate clause error in the SQL server.
    Salman Beg Dec 17, 2019
  • Mageshwaran R

    Transaction Explained in SQL Server

    In this blog, I will explain the SQL Transaction.
    Mageshwaran R Dec 14, 2019
  • Destin Joy

    How Stellar Repair for MS SQL Fixed Corruption in MS SQL Server Database

    There are many issues when we work with SQL server. This blog will introduce a tool which we can use to repair corrupted SQL Server DBS
    Destin Joy Dec 14, 2019
  • Govardhan P

    Creating a custom sequence in MS-SQL Server.

    This blog post is for advanced T-SQL developers interested in implementing custom sequences. Customizing the sequence gives more flexibility while implementing a solution.
    Govardhan P Dec 01, 2019
  • Kumaran K

    Delete All Duplicate Rows or Records from a Table in SQL Server

    In this blog, you will learn how to delete all duplicate rows or records from a table in SQL Server
    Kumaran K Nov 30, 2019
  • Kumaran K

    Static and Dynamic Pivot Query in SQL Server

    This post explains static and dynamic pivot query in SQL Server
    Kumaran K Nov 30, 2019
  • Mageshwaran R

    Cursor Explained in SQL Server

    In this blog, I will explain the SQL Cursor.
    Mageshwaran R Nov 27, 2019
  • Govardhan P

    Altering the table Structure using the DDL command ALTER in SQL - Part 1

    The commands in this blog will help you to understand the way a table structure can be changed or altered. In this blog, one can find examples related to adding new columns, removing unwanted colum...
    Govardhan P Nov 25, 2019
  • Govardhan P

    Altering table structure using the DDL command ALTER

    This blog post is related to the ALTER command. Whenever we want to change the structure of the table we can use the following commands as mentioned in this blog.
    Govardhan P Nov 20, 2019
  • Mageshwaran R

    Indexes Explained in SQL Server

    In this blog, I will explain indexes in SQL Server.
    Mageshwaran R Nov 20, 2019
  • Mageshwaran R

    View Explained In SQL Server

    In this blog, I will explain SQL View
    Mageshwaran R Nov 20, 2019
  • Mageshwaran R

    Triggers Explained in SQL Server

    In this blog, I will explain SQL Triggers.
    Mageshwaran R Nov 20, 2019
  • Mageshwaran R

    Stored Procedures in SQL Server

    In this blog, I will explain the SQL Stored Procedure
    Mageshwaran R Nov 18, 2019
  • Mageshwaran R

    JOIN Statements in SQL Server

    In this blog, I will explain SQL JOIN Statements. These are used to relate one or more tables in SQL Server
    Mageshwaran R Nov 18, 2019
  • Govardhan P

    Entity Integrity Constraints - Primary Key and Unique constraints

    Basics about Data Integrity Constraints. Why and when to use a constraint is explained in this document with respect to Entity Integrity Constraint using Primary Key and Unique constraints.
    Govardhan P Nov 18, 2019
  • Mageshwaran R

    User-Defined Functions in SQL Server

    In this blog, I will explain SQL user-defined functions
    Mageshwaran R Nov 17, 2019
  • Mageshwaran R

    SQL Constraints Explained

    In this blog, I will explain the SQL Constraints.
    Mageshwaran R Nov 11, 2019
  • Mageshwaran R

    Logical operators in SQL Server Explained

    In this blog, I will explain SQL operators. SQL operators are used as arithmetic, logical and bitwise operators.
    Mageshwaran R Nov 11, 2019
  • View More