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

  • M.Qassas

    SQL Server - Get The Computer Name On Which The SQL Server Instance Is Running

    Get the computer name on which the SQL server instance is running via "ServerProperty"
    M.Qassas Nov 24, 2017
  • M.Qassas

    SQL Server - Get The Full SQL Server Instance Name

    Get the full SQL Server instance name via "ServerProperty". In this blog, we will simply show How to Get the full SQL Server Instance Name using "SERVERPTOPERTY".
    M.Qassas Nov 24, 2017
  • Muhammad Zunair

    Introduction To SSIS

    SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Da...
    Muhammad Zunair Nov 24, 2017
  • Mahesh Chand

    Use SQL Server 2017 in Docker Containers

    How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
    Mahesh Chand Nov 21, 2017
  • Satyaprakash Samantaray

    Introduction To SQL Operations Studio And Connecting It With SQL Server

    Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • Suvendu Shekhar Giri

    Transact SQL Code Snippets

    A Transact-SQL code snippet is a template containing the basic structure of a Transact-SQL statement or block. You can use snippets as a starting point when adding statements in the Database Engine...
  • Dharmraj Thakur

    Group By Vs Distinct Difference In SQL Server

    Difference between GROUP BY clause and DISTINCT in sql server. When and where to use GROUP BY and DISTINCT.
    Dharmraj Thakur Nov 17, 2017
  • Mahesh Chand

    What Is SQL Operations Studio

    Learn and download SQL Operations Studio
    Mahesh Chand Nov 17, 2017
  • Saravanan V

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

    This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certifi...
    Saravanan V Nov 16, 2017
  • Suvendu Shekhar Giri

    SSMS 2016 - Enhanced Scrollbar

    Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • Suvendu Shekhar Giri

    DROP IF EXISTS In SQL Server 2016

    With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the ob...
  • Suvendu Shekhar Giri

    Masking Sensitive Data With SQL Server 2016

    SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side ...
  • Suvendu Shekhar Giri

    Introduction Of New Useful Features In SSMS 2016

    This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our w...
  • 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
  • M.Qassas

    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.
    M.Qassas Nov 06, 2017
  • 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.
  • M.Qassas

    T-SQL - Display Decimal Numbers As Money

    In this article, we will show how to display decimal numbers as money with and without cents
    M.Qassas Oct 17, 2017
  • 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
  • View More