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

  • Sateesh Arveti

    SQL Server - Invalid Column Name ‘ABC’ Error While Accessing Newly Added Column

    In this blog, we will look into steps to be followed for fixing invalid column name ‘ABC’ Error while accessing a newly-added column.
    Sateesh Arveti Jan 22, 2018
  • Sateesh Arveti

    Introduction To SQL Server Pagination

    In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
    Sateesh Arveti Jan 22, 2018
  • Dennis Thomas

    Stored Procedures Vs User Defined Functions And Choosing Which One To Use

    In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply funct...
    Dennis Thomas Jan 16, 2018
  • Suraj Krishnan

    Comparison Of Subquery And Joins

    Here, in this article, we are comparing the SQL Join and SQL Subquery.
    Suraj Krishnan Jan 15, 2018
  • Priti Kumari

    Why Dynamic Query Is Bad

    In this article, we will be talking about Dynamic Query and why it is bad.
    Priti Kumari Jan 15, 2018
  • Sateesh Arveti

    Understanding SQL Server Transparent Data Encryption

    In this video, we will look into the encryption of SQL Server Database using TDE.
    Sateesh Arveti Jan 15, 2018
  • Dharmraj Thakur

    Why SELECT Is Called DML

    The word “Manipulation” means to play with the data, not only retrieve or fetch the data. We can include retrieve, store, modify, delete, insert, update and copy operations in DML.
    Dharmraj Thakur Jan 14, 2018
  • Nishan Aryal

    How To Backup All Databases In SQL Server

    When we have more databases on a Server to backup, it is very time-consuming to backup all databases manually. In such cases, we can use T-SQL to automate these tasks. We can use SQL Server Managem...
    Nishan Aryal Jan 11, 2018
  • Jaipal Reddy

    Difference Between Primary key, Unique key And Foreign Key

    In this blog we will learn the basic differences between Primary key, Unique key and Foreign key.
    Jaipal Reddy Jan 09, 2018
  • Sateesh Arveti

    Introduction To SQL Server Dynamic Data Masking

    In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
    Sateesh Arveti Jan 09, 2018
  • Nirav Daraniya

    Store And Retrieve Using FILESTREAM From SQL Database

    Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my p...
    Nirav Daraniya Jan 06, 2018
  • Sateesh Arveti

    Look At SQL Server Encryption - Part I

    In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.
    Sateesh Arveti Jan 05, 2018
  • Nirav Daraniya

    FILESTREAM Feature In SQL Server

    Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
    Nirav Daraniya Jan 04, 2018
  • Nikunj Satasiya

    Remove Duplicate Records From A Table In SQL Server

    In this blog i am going to explain how to remove duplicate records from a table in SQL Server.
    Nikunj Satasiya Jan 03, 2018
  • Sagar Shinde

    Using CASE Statements In A SQL UPDATE Query

    I have SQL server Table in which there is column that I wanted to update according to a 2 columns value that are present in current row. In this scenario, we can use CASE expression. CASE expressio...
    Sagar Shinde Dec 20, 2017
  • Sagar Shinde

    Export SQL Result To A Text File

    This article gives an overview of how to export SQL query results to a text file.
    Sagar Shinde Dec 18, 2017
  • Manish Pandey

    SQL QUERY With CONVERT And VARCHAR

    Email Address is truncated with the use Convert and Varchar.
    Manish Pandey Dec 13, 2017
  • Andrew Jackson

    Transfer Database From SQL Server 2008 To 2014

    Transfer database from SQL Server 2008 to 2014 using different migration techniques with the help of this article.
    Andrew Jackson Dec 12, 2017
  • Nakul Chaudhari

    Remove Duplicate Rows In SQL Server Using CTE

    In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
    Nakul Chaudhari Dec 11, 2017
  • Pramod Thakur

    Ways Of Finding Foreign Key In SQL Server

    In this blog, we are trying to find in how many ways, we can find foreign key in SQL Server.
    Pramod Thakur Dec 09, 2017
  • Sundar

    Roles And Responsibilities Of SQL Developer

    In this article, I have shared the Roles and Responsibilities of a SQL Developer.
    Sundar Dec 09, 2017
  • Nikunj Satasiya

    How To Pass Output Parameter To Stored Procedure In SQL Server

    In this tutorial, I will explain how to pass the output parameter to a stored procedure in MS SQL Server.
    Nikunj Satasiya Dec 08, 2017
  • Bhuvanesh Mohankumar

    Audit Made Easy Without Audit Log - Part One

    In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • Mohamed Elqassas Mvp

    SQL Server 2017 - Check The Advanced Analytics Status

    Check the Advanced Analytics status using SERVERPROPERTY In SQL Server 2017/2016
  • Mohamed Elqassas Mvp

    SQL Server - Check If The Failover Cluster Is Configured Or Not

    Check if the failover cluster is configured or not using SERVERPROPERTY In SQL Server.
  • View More