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.

Blogs

  • Jeeva Subburaj

    Simultaneous Data Queue Polling Request Processing In SQL Server

    This article explains how to implement simultaneous data queue processing using SQL Server. In many of our enterprise applications, we have the design to handle incoming request coming from multip...
    Jeeva Subburaj May 24, 2018
  • Karthikeyan Sekar

    Stuff Function In SQL Server

    Stuff is a function in SQL Server used to perform special operations on a string value.
    Karthikeyan Sekar May 16, 2018
  • Ruchi Sharavat

    Save Array Or List Of Records As XML Data To SQL Server In One Call

    In this blog, we will discuss the way to submit the data of a model list to SQL Server to save all records of the list at once. We can do this by converting the model list to XML and then that XML ...
    Ruchi Sharavat May 01, 2018
  • Bohdan Stupak

    Money Precision Issues

    This blog shows some primary issue which puts a serious limitation on SQL Server MONEY data type.
    Bohdan Stupak May 01, 2018
  • Farhan Ahmed

    How To Find The Highest Number Of Employees In a Department Using SQL Server

    In this blog, I will demonstrate how to find the highest number of employees in a particular department using SQL server 2014.
    Farhan Ahmed May 01, 2018
  • Farhan Ahmed

    How To Find The Highest Salary In SQL Server

    In this blog we will discuss how to find the highest salary, the second highest salary and N number of highest salaries with different examples.
    Farhan Ahmed Apr 17, 2018
  • Farhan Ahmed

    How To Get A Stored Procedure Encrypted In SQL Server

    In this blog, we are going to learn how to get a stored procedure encrypted.
    Farhan Ahmed Apr 11, 2018
  • Shahriar Nikkhah

    Looping Through Flat Files Using SSIS 2016

    It's been a long time and I see that everyone is still using old SSIS packages from 2005 up to 2012, but I generally don't see new techniques or approaches being used. So, I decided to writ...
    Shahriar Nikkhah Apr 09, 2018
  • Shahriar Nikkhah

    Document And Track Changes In Your Tabular Model

    I had a SSAS Tabular Model project and I had few developers making changes on the fly without telling me. My biggest problem was I couldn't track the changes and my client had lots of requireme...
    Shahriar Nikkhah Apr 09, 2018
  • Aniket Narvankar

    Temporary Tables In SQL

    This blog is about temporary tables in SQL, their types, and differences between them.
    Aniket Narvankar Apr 03, 2018
  • Nikunj Satasiya

    Insert XML Data In Database Using Stored Procedure In SQL Server

    In this article, I’ll explain how to insert data from XML Sheets using SQL server.
    Nikunj Satasiya Mar 24, 2018
  • Harinder Kumar

    Some Useful And Tricky Queries

    Today, I am going to share some useful and tricky SQL queries that have helped me a lot.
    Harinder Kumar Mar 12, 2018
  • Padmalatha Dronamraju

    Temporary Tables In SQL Server

    Often as a developer, we come upon a situation where we want to store some intermediate results temporarily. So in such cases, Sql Server provides us with a feature called temporary tables which ca...
  • Israr Ali

    A Scenario Based SQL Interview Queries/ Test Model/Training

    A scenario-based SQL interview queries with the schema which is equally meaningful for new students as training material.
    Israr Ali Mar 07, 2018
  • Nitin Sontakke

    Interview Question I Couldn't Answer

    I consider myself fairly good at SQL Server but couldn't answer a question.
    Nitin Sontakke Feb 26, 2018
  • Surinder Bhomra

    Alternative To SQL "In" Condition When Working With Many Values

    In this post, we will be discussing an alternative to using a SQL “IN” condition, where many values need to be parsed to the SQL query through the use of a User Defined Data Type to get exact recor...
    Surinder Bhomra Feb 20, 2018
  • Prashanth J

    Passing Multiple Parameters In SQL IN Clause With SQL Command

    Today, I am going to discuss about retrieving the records based on the values in a specific column in SQL database using "IN CLAUSE".
    Prashanth J Feb 01, 2018
  • 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
  • Dharmraj Thakur

    Why SELECT Is 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 10, 2018
  • View More
    X

    Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

    Start Learning Now