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

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

    "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.
  • Rafnas T P

    Taking Scripts From SQL Server

    In this article, you will learn about taking scripts from SQL Server.
    Rafnas T P Apr 27, 2017
  • rupali patil

    Why Stored Procedures Are Outdated

    This blog demonstrates why stored procedures are outdated.
    rupali patil Apr 26, 2017
  • Pravat Kumar

    Tips To Increase SQL Server Stored Procedure Performance

    This blog presents tips to increase SQL Server stored procedure performance.
    Pravat Kumar Apr 25, 2017
  • Priyaranjan K S

    SQL Server 2016 - Getting Started With Row Level Security Feature

    This article familiarizes you with SQL Server 2016 - Getting started with Row Level Security feature.
    Priyaranjan K S Apr 25, 2017
  • Ramesh Palanivel

    Get Database Backup And Restore The Backup File In SQL Server

    In this article, we are going to learn how to get database backup from SQL Server and how to restore the backup file in SQL Server.
    Ramesh Palanivel Apr 25, 2017
  • Rafnas T P

    Commonly Used Built In String Functions In SQL Server

    This article illustrates commonly used built in string functions in SQL Server.
    Rafnas T P Apr 25, 2017
  • Satyaprakash Samantaray
  • Satyaprakash Samantaray

    Local And Global Temporary Tables Using Stored Procedure In SQL Server

    Temporary tables are created in TempDB database and are automatically deleted, when they are no longer used.
  • Satyaprakash Samantaray

    Case Statement Using Stored Procedure In Real Time Scenarios

    Case statement is mostly used in Real Time scenarios
  • Satyaprakash Samantaray

    Alter Table Columns And Datatypes Without Deleting The Table

    This article emphasizes that there is no need to delete a whole table. Instead, write SQL query to get this result.
  • Satyaprakash Samantaray

    UNPIVOT Operator Using Stored Procedure In SQL Server

    UNPIVOT operator is the reverse process of PIVOT operator.
  • Satyaprakash Samantaray

    SET NOCOUNT ON And SET NOCOUNT OFF Using Stored Procedure In SQL Server

    This blog illustrates SET NOCOUNT ON and SET NOCOUNT OFF, which are very useful in real time scenarios inside stored procedure in SQL Server.
  • Satyaprakash Samantaray

    INSTEAD OF DELETE Triggers And View

    INSTEAD OF DELETE TRIGGERS are used, to delete records from a view.
  • Satyaprakash Samantaray

    INSTEAD OF UPDATE Triggers And View

    INSTEAD OF UPDATE TRIGGERS correctly update a view.
  • Deepak

    Upgrading SQL Server When It Is Part Of Availability Group

    Upgrading SQL Server When It Is Part Of Availability Group.
    Deepak Apr 20, 2017
  • Pravat Kumar

    Delete Duplicate Records From A Table In SQL Server

    This blog acquaints you with deleting duplicate records from a table in SQL Server, using ROW_NUMBER.
    Pravat Kumar Apr 19, 2017