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

  • 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
  • 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
  • Saravanan V

    Optimizing Stored Procedures In SQL Server

    This post provides some guidance on improving the slow performance stored procedures.
    Saravanan V May 30, 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
  • Pravat Kumar

    ColumnStore Index In SQL Server

    This blog exhibits Columnstore Index in SQL Server.
    Pravat Kumar 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
  • 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
  • Pravat Kumar

    Some Simple Queries That Might Be Helpful

    Some simple queries that might be helpful
    Pravat Kumar May 13, 2017
  • 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.
  • 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

    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

    Trigger For Creating New Table In SQL Server

    Triggers are associated with the table or view directly.
  • 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

    "EXISTS" Condition In SQL Server To Check Existence Of Tables And Stored Procedures In Real Time ...

    The "exists" condition is used to check if there is any table and stored procedure with that name.
  • Satyaprakash Samantaray

    "Created Data Time And Collation Name" Of Table And Stored Procedure In SQL Server

    By executing a SQL query, we can get detailed information about what date and time the table and stored procedure were created.
  • Satyaprakash Samantaray