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

  • Vishal Pawar

    How To Create A Solution And What Its Uses Are

    How to create a Solution and what its uses are.
    Vishal Pawar May 25, 2017
  • Vishal Pawar

    All About Primary Key And Its Basics

    All About Primary Key And Its Basics
    Vishal Pawar May 24, 2017
  • Nemi Chand

    Move SQL Server Database To Another Location - Lesson Learned

    Fix: Unable to open the physical file. Operating system error (Access is denied.). In this article, we'll learn the best practice of moving database to another physical location on the Server.
    Nemi Chand May 22, 2017
  • Deepak

    High Availability And Disaster Recovery In SQL Server - A Quick Note

    High Availability And Disaster Recovery - A Quick Note.
    Deepak May 20, 2017
  • Dipendra Singh Shekhawat

    Temporary Tables And Table Variables In SQL

    In this article, I will explain the difference between temporary tables and table variables in SQL server.
  • Pravat Kumar

    ColumnStore Index In SQL Server

    This blog exhibits Columnstore Index in SQL Server.
    Pravat Kumar May 16, 2017
  • Asad Ali

    Getting Ado Connection From Nhibernate

    This blog show you how to use the nhibernate connection and transaction instead of opening a new ado connection.
    Asad Ali May 16, 2017
  • Deepak

    Resolving Connection Errors In SQL Server Multi-Subnet Availability Group

    In this blog, I am trying to explain how I solved "connection timeout" errors while executing SQL Jobs, which are part of primary node in "AlwaysOn" multi subnet AG setup
    Deepak May 16, 2017
  • Sourabh Somani

    How To Find All Months Of a Particular Quarter In SQL Server

    In this blog, you will learn how you can find all the months of a particular quarter.
    Sourabh Somani May 16, 2017
  • Zahid Mustafa

    Connect To SQL Server Error 40, 2

    Sometimes this happens when you start Windows and Open Microsoft SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not ...
    Zahid Mustafa May 16, 2017
  • Madhan Raghu

    Extract JSON Data Using Custom DLL In SSRS

    This article enables you to extract JSON data, using custom DLL in SSRS.
    Madhan Raghu May 15, 2017
  • Pravat Kumar

    Some Simple Queries That Might Be Helpful

    Some simple queries that might be helpful
    Pravat Kumar May 13, 2017
  • Dipendra Singh Shekhawat

    Ten SQL Server Shortcuts You Must Know

    Ten SQL Server Shortcuts You Must Know.
  • Satyaprakash Samantaray

    User-Defined Table Type and Table Valued Parameters In Stored Procedure To Reduce The Code Size I...

    Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure.
  • Yashwant Vishwakarma

    Installing SQL Server vNext On Linux - Part One

    Installing SQL Server vNext On Linux.
  • Satyaprakash Samantaray

    Find List Of Tables Used In Stored Procedure Using Types Of Joins

    This blog enables you to find the list of tables used in the stored procedure, using types of joins.
  • Sateesh Arveti

    Resolving "Cannot Connect To .\sqlexpress Using SQL Server Authentication"

    In this blog, we will understand how to resolve "cannot connect to a local\remote SQL Server instance using SQL Server authentication with a error code: 18456".
    Sateesh Arveti May 08, 2017
  • Satyaprakash Samantaray

    Apply Div Tag In Stored Procedure Using SQL Server To Add Body , Header , Footer Text Details In ...

    In this blog, I have added div tag in the stored procedure, as I used in ASP.NET html.
  • Satyaprakash Samantaray

    Generate JSON Data Using Web Service And SQL Server Stored Procedure

    Generate JSON Data Using Web Service And SQL Server Stored Procedure.
  • Satyaprakash Samantaray

    Trigger For Creating New Table In SQL Server

    Triggers are associated with the table or view directly.
  • Piyush Pansuriya

    SQL Server - Execution Plans

    Execution plan will be generated by Query optimizer with the help of statistics and Algebrizer/ processor tree. It is the result of Query Optimizer and tells how to do/ perform your work/ requireme...
    Piyush Pansuriya May 01, 2017
  • Satyaprakash Samantaray
  • Ashutosh Mund

    Aborting/ Killing A Long Running Stored Procedure

    This blog acquaints you with aborting/ killing a long running stored procedure.
    Ashutosh Mund Apr 28, 2017
  • Amit Kumar

    How To Check If A String Contains A Substring In SQL Server

    This blog explains how to check, if a string contains a substring in SQL Server or not.
    Amit Kumar Apr 28, 2017
  • Satyaprakash Samantaray
  • View More