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

  • Raviteja Swayampu

    Concept Of Views In SQL Server

    In this article you will learn about the concept of views in SQL Server.
    Raviteja Swayampu Sep 23, 2017
  • Nitesh Jha

    How To Secure PII Data In SQL Server Using .NET Assembly

    PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scen...
    Nitesh Jha Sep 21, 2017
  • Hamid Khan

    ACID Properties In SQL

    ACID properties are atomicity, consistency, isolation, and durability.
    Hamid Khan Sep 19, 2017
  • Tushar Dikshit

    35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews

    These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
    Tushar Dikshit Sep 19, 2017
  • M.Qassas

    Convert Rows To Columns Using Dynamic Pivot In SQL Server

    In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
    M.Qassas Sep 17, 2017
  • M.Qassas

    Create Log Backup Maintenance Plan In SQL Server 2016

    In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
    M.Qassas Sep 17, 2017
  • Ramesh Palanivel

    SQL Server DB Backup Using Stored Procedure In WinForm Application

    In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
    Ramesh Palanivel Sep 14, 2017
  • Vishal Pawar

    How Should We Store Images And Blob Files In SQL Server

    There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objec...
    Vishal Pawar Sep 07, 2017
  • Satyaprakash Samantaray

    Find Out Creation And Modification Date Of Database Objects Like Tables And Stored Procedures

    Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • Nitesh Jha

    How To Consume Web API Through SSIS Package

    In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and pro...
    Nitesh Jha Sep 07, 2017
  • Saravanan Ponnusamy

    Different Ways To Use GETDATE() Function In SQL Server 2008 R2

    This blog will list different ways to use GETDATE() funtion in SQL Server 2008 R2. The major changes in the new SQL Server 2008 are the DateTime function and the introduction of new data types.
  • Anil Avula

    SQL Server Setup Or Installation Failure Errors

    SQL Server 2008 R2 setup failed with “Error 1406. Could not write value to key \SOFTWARE. System error. Verify that you have sufficient access to that key, or contact your support personnel”.
    Anil Avula Sep 06, 2017
  • Jignesh Trivedi

    New String Function In SQL Server 2017

    It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
    Jignesh Trivedi Sep 06, 2017
  • Vishal Pawar

    How To Backup A Mirrored Database Using SQL Agent

    Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery m...
    Vishal Pawar Sep 04, 2017
  • Jignesh Trivedi

    Working With JSON In SQL Server 2016

    JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very p...
    Jignesh Trivedi Aug 28, 2017
  • Jignesh Trivedi

    New Features In SQL Server 2017

    There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new f...
    Jignesh Trivedi Aug 28, 2017
  • Nisarg Upadhyay

    Parameter Sniffing In SQL Server

    SQL Server uses a process called parameter sniffing when it executes a stored procedure that has parameters. When the procedure is compile or recompiled, the value passed in the parameter is evalua...
    Nisarg Upadhyay Aug 23, 2017
  • Junaid Syed

    Merging Table Data Using Merging Statement In MSSQL 2012

    In this blog, we will learn how we can merge the table data using merging statement.
    Junaid Syed Aug 23, 2017
  • Nitesh Jha

    How To Consume Web Service Through SSIS Package

    This article illustrates the purpose of SSIS with Web Service.
    Nitesh Jha Aug 19, 2017
  • 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
  • Anil Jha

    Select All Columns From A Table Except One Column

    Usually, we use * to select all the columns but if we have to select all the columns except one column, then we have to write all the required columns one by one. Here I am going to show how we can...
    Anil Jha Aug 09, 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
  • Anoop Kumar Sharma

    Setup AdventureWorks Database In Microsoft SQL Server 2014

    In this blog, we will learn how to setup AdventureWorks Database in Microsoft SQL Server 2014.
    Anoop Kumar Sharma Aug 08, 2017
  • Jothish Kumar

    Password Encryption And Decryption In SQL SP

    In this blog, I have explained the process involved in the password security using Encryption and Decryption in SQL Stored Procedure.
    Jothish Kumar 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
  • View More