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

  • Saravanan V

    The What, When, and How of Indexed Views

    This blogs talks about Indexed Views in SQL Server and the pros and cons of using them.
    Saravanan V Jul 06, 2017
  • Santosh Kumar

    Difference Between Stored Procedure And User Defined Function In SQL Server

    This article describes the differences between Stored Procedures and User Defined Functions in SQL Server.
    Santosh Kumar Jul 06, 2017
  • Yashwant Vishwakarma

    Installing SQL Server vNext On Linux - Part Two

    With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on...
  • Nisarg Upadhyay

    Generate Table Definition In SQL Server Without GUI

    This script will create table definition along with unique key, primary key and indexes.
    Nisarg Upadhyay Jul 04, 2017
  • Saillesh Pawar

    Wild Card Operators In SQL

    This article explains Wild Card Operators in SQL. Wildcard characters can be used in LIKE expressions; the percent sign (%) matches zero or more characters and underscore (_) a single character.
    Saillesh Pawar Jun 28, 2017
  • Thiruppathi R

    Convert Table Column Into C# Model Class

    In this blog, I will demonstrate how to convert a table column in C# model class, using stored procedure.
    Thiruppathi R Jun 27, 2017
  • Nisarg Upadhyay

    How To Fix Error - "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQL...

    In this blog, you will learn how to fix the error - "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE'.
    Nisarg Upadhyay Jun 27, 2017
  • Nisarg Upadhyay

    How To Read SQL T-Log File

    Using this function, we can get a list of all transactions performed in the database. Function name is fn_dblog() (Formally known as DBCC command).
    Nisarg Upadhyay Jun 27, 2017
  • Jasminder Singh

    Row Number Function 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 Jun 27, 2017
  • Jasminder Singh

    Rank Function in SQL Server

    This article explains the Rank function. 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 functions available...
    Jasminder Singh Jun 27, 2017
  • Venkatesan Jayakantham

    Time datatype in SQL Server 2008

    Time data type is a one of the new data type introduced in SQL Server 2008. It provided you the time with the accuracy of 100 nanoseconds.
  • Abhijit  Patil

    Indexes in SQL Server

    This article describes indexes in SQL Server. Indexes are used in relational databases to quickly retrieve the data.
    Abhijit Patil Jun 26, 2017
  • Ritesh Sharma

    Over Clause in Sql Server (Windows on Data): Part 1

    This article explains how the Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005. Windowing of data in SQL Server or the window function is...
    Ritesh Sharma Jun 26, 2017
  • Vignesh Mani

    Daily Shrink Database Log Automatically Using Jobs In SQL Server

    This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script...
    Vignesh Mani Jun 24, 2017
  • Deepak Middha

    Role in SQL Server

    In this article I described Role in SQL Server. Roles are a collection of permissions or access rights for providing permissions or privileges easily in a large database system with multiple users.
    Deepak Middha Jun 23, 2017
  • Pramod Thakur

    Count Word In SQL Server

    In this blogI am going to write a function which returns the word count in sql server.
    Pramod Thakur Jun 22, 2017
  • Vignesh Mani

    Automatic Daily Database Backup To Specific Database In SQL Server

    Automatic Daily Database Backup To Specific Database In SQL Server.
    Vignesh Mani Jun 21, 2017
  • Thiruppathi R

    MS-SQL To JD Edwards Date Conversion

    This blog helps to understand how we can do MS-SQL to JD Edwards date conversion.
    Thiruppathi R Jun 20, 2017
  • Gaurav Tomar

    Using Stored Procedures with ASP.NET

    This article helps you to create a stored procedure on SQL Server and tells you how to use them in your asp.net applications.
    Gaurav Tomar Jun 16, 2017
  • Vishal Pawar

    To Get All File Details From Local File Into SQL Server

    TO Get All File Details From Local File Into SQL Server.
    Vishal Pawar Jun 15, 2017
  • Vishal Pawar

    Concept Of Change Data Capture (CDC) In SQL Server - Part Three

    Concept Of Change Data Capture (CDC) In SQL Server.
    Vishal Pawar Jun 13, 2017
  • Vishal Pawar

    Concept Of Change Data Capture (CDC) In SQL Server - Part Two

    Concept Of Change Data Capture (CDC) In SQL Server.
    Vishal Pawar Jun 12, 2017
  • Vishal Pawar

    Concept Of "Change Data Capture" (CDC) In SQL Server - Part One

    Concept Of Change Data Capture (CDC) In SQL Server 2008.
    Vishal Pawar Jun 09, 2017
  • Vishal Pawar

    Top Ten Things You Should Know About Optimizing SQL Server Performance - Part Two

    Top Ten Things You Should Know About Optimizing SQL Server Performance.
    Vishal Pawar Jun 08, 2017
  • Vishal Pawar

    Top Ten Things You Should Know About Optimizing SQL Server Performance - Part One

    Top 10 Things You Should Know About Optimizing SQL Server Performance.
    Vishal Pawar Jun 07, 2017