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

  • Agus Suhanto

    Configuring SQL Server 2016 Express On LAN For C# Connection String

    In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
    Agus Suhanto Nov 08, 2017
  • Sagar Shinde

    Computed Columns In SQL Server

    This article will help the user to write a complex calculation in the backend (SQL SERVER). A computed column is computed from an expression that can use other columns in the same table.
    Sagar Shinde Nov 07, 2017
  • Madhan Raghu

    Step By Step Guide To Setup Sample SSAS Multi Dimension Cube

    Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
    Madhan Raghu Nov 06, 2017
  • Mohamed Elqassas Mvp

    SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed

    In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
  • Ravi Kiran Chanduri

    User-Defined Types In SQL Server

    When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Mohamed Elqassas Mvp

    T-SQL - Display Decimal Numbers As Money

    In this article, we will show how to display decimal numbers as money with and without cents
  • Catcher Wong

    Sharing A Solution To Generate Billcode

    Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a spec...
    Catcher Wong Oct 16, 2017
  • Saravanan V

    Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two

    This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Alwa...
    Saravanan V Oct 14, 2017
  • Morteza Mousavi

    SQL UNION Operator

    The SQL UNION operator combines two or more SELECT statements.
    Morteza Mousavi Oct 13, 2017
  • Saravanan V

    Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One

    Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we nee...
    Saravanan V Oct 06, 2017
  • Nitesh Jha

    How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)

    PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scena...
    Nitesh Jha Oct 03, 2017
  • Nikunj Satasiya

    Write And Execute Dynamic SQL Query In SQL Server

    This example demonstrates how to write and execute dynamic SQL Query in SQL Server. You can execute the Query using EXEC sql command and sp_executesql commands in SQL Server.
    Nikunj Satasiya Sep 28, 2017
  • Talaviya Bhavdip

    How To Find Which Table Record Count Increases Or Decreases In SQL Server

    In this blog, the user can find out in which table records are deleted or inserted.
    Talaviya Bhavdip Sep 26, 2017
  • 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
  • Mohamed Elqassas Mvp

    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.
  • Mohamed Elqassas Mvp

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