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.

Articles

  • Madhan Raghu

    Load Twitter Data Into SQL Database

    The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load th...
    Madhan Raghu Aug 15, 2017
  • Srashti Jain

    Create SQL Server Database Project With Visual Studio

    In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
    Srashti Jain Aug 08, 2017
  • Vishal Pawar

    How To Determine The Version And Edition Of SQL Server And Its Components

    For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the...
    Vishal Pawar Aug 06, 2017
  • Prakash kumar Jha

    Online Shopping Website In ASP.NET- Open Source Project

    This is an open source project I named online shopping site.This is an online shopping cart application written in ASP.NET (4.0) and C# where a user can browse, add items to the shopping cart and p...
    Prakash kumar Jha Oct 26, 2011
  • Rahul Bansal

    Find The 3rd Or Nth Highest Salary In A Table Via SubQuery

    This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the fo...
    Rahul Bansal Feb 14, 2014
  • Vikrant More

    Statistics And Cost Estimation Internals - Part One

    Incorrect cardinality and Cost Estimation may lead query optimizer to choose inefficient plans which can have a negative impact on the database performance. In this article we are going to look dee...
    Vikrant More Jul 30, 2017
  • Vishal Nayan

    Creating And Managing Stored Procedure In SQL Server 2008

    In this article you will learn how to Create and Manage Stored Procedure in SQL Server 2008.
    Vishal Nayan Sep 02, 2011
  • Vadim Loboda

    Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical Data

    How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
    Vadim Loboda Jul 26, 2017
  • Vignesh Mani

    Taking Script From Database In SQL Server In Different Mode

    This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter,...
    Vignesh Mani Jul 17, 2017
  • Jayesh  Agrawal

    Create SSRS Drilldown Report

    Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
    Jayesh Agrawal Jul 17, 2017
  • Pankaj Sapkal

    Mirroring Database In SQL Server

    When there is any automatic failure we need another server that will monitor the principal server.
    Pankaj Sapkal Jul 12, 2017
  • Deepak Kaushik

    Creating And Using Azure SQL Server And Azure SQL Database

    This article helps you in creating and using SQL Server and SQL database.
    Deepak Kaushik Apr 01, 2017
  • Vignesh Mani

    Monitoring Our Database When Accessing From Outside Or Applications In SQL Server

    This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
    Vignesh Mani Jul 08, 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 Sep 24, 2013
  • 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...
  • 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 Aug 02, 2015
  • 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 19, 2014
  • 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 21, 2014
  • 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 19, 2014
  • 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 Aug 17, 2014