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

  • Temporary Stored Procedures in SQL Server

    In this article, I highlight a small feature of Temporary Stored Procedures in SQL Server. Temporary Stored Procedures are similar to normal Stored Procedures, and are two kinds of temporary Stored Pr
  • SQL Server Database Mirroring: Part 3

    Here you will see SQL Server Database Mirroring. Database Mirroring is used to move the database transactions from one SQL Server database (Principal database) to another SQL Server database (Mirror d
  • SQL Server Database Mirroring: Part 2

    You can read SQL Server Database Mirroring. Database Mirroring is used to move the database transactions from one SQL Server database (Principal database) to another SQL Server database (Mirror databa
  • SQL Server Database Mirroring: Part 1

    In SQL Server Log Shipping and Mirroring can work together to provide solutions for high availability and disaster recovery. Database Mirroring is used to move the database transactions from one SQL S
  • Copy Table Schema and Data From One Database to Another Database in SQL Server

    This article is all about how to copy SQL Server table schemas and data from one database to another database.
  • Full Text Index In SQL Server

    In this article you will learn about Full Text Index In SQL Server.
  • Database and SQL Server FAQ: Part I

    This article is a primer on databases and Sql Server. Similar to a FAQ, it is written with questions that could potentially be asked in a job interview.
  • T-SQL - Display Decimal Numbers As Money

    In this article, we will show how to display decimal numbers as money with and without cents
  • Creating Check Constraint on a Table in SQL Server 2012

    This article will give you an idea of how to use the SQL Server Check Clause and also defines where you can use it.
  • Understanding and handling SQL Server Transaction Deadlocks

    Deadlocks occur when two users have locks on separate objects and each user wants a lock on the other's object.
  • Using Isolation Level In SQL Transaction

    In this session, I am going to discuss what is isolation level in SQL Transaction and their depth of usage.
  • Normalization and its Types

    Normalization is the process of organizing data into a related table; it also eliminates redundancy and increases the integrity which improves performance of the query.
  • SQL Operators

    A SQL Operator is used for arithmetic, logical, and bitwise operations. This SQL Operators tutorial explains SQL Arithmetic Operators, SQL Assignment Operator, SQL Bitwise Operator, and SQL Logical Op
  • SQL Server Important System Views and Tables

    This article list out the important system tables, stored procedure and views.
  • NTile Function in SQL Server

    This article explains the NTile rank function in SQL Server.
  • 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 trig
  • Bulk Insert task in SSIS

    In this article, we are going to see how to use Bulk Insert task in SSIS.
  • Static Cursor, Dynamic Cursor, and Keyset-Driven Cursor in SQL Server

    In this article, I describe Static Cursor, Dynamic Cursor, and Keyset-Driven Cursor.
  • Dropping All Stored Procedure in Database in SQL Server 2012

    In this article, I describe how to drop all the Stored Procedures in a particular database.
  • Pagination in SQL Server 2012

    In this article, we will compare the pagination mechanism between previous versions and how the same can be done in SQL Server 2012.
  • Left and Right Join in SQL Server

    In this article, I will describe how to perform left and right outer join between more than one tables in SQL Server 2008.
  • 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.
  • Aggregate (Group By) Transformations Control in SSIS

    This is part 32 of the series of articles on SSIS. In this article we are going to see how to use an Aggregate (Group by) data flow transformation control in SSIS packaging.
  • Calculating Factorial of a Number in SQL Server 2012

    Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.
  • SQL Join Query With LINQ

    In this article, I will show you how to create SQL queries in LINQ. LINQ Join queries.