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

  • Prachee Mishra

    SQL Vs TSQL

    SQL Server is a relational database management system (RDBMS) developed by Microsoft. T-SQL (Transact-SQL) is an extension of SQL language.
    Prachee Mishra Apr 06, 2021
  • Hamid Khan

    RAND Function In SQL

    In this blog, you will learn about RAND Function In SQL.
    Hamid Khan Mar 12, 2021
  • Arkadeep De

    Change The Azure SQL Pricing Tier Using SQL Query

    In this blog, you will learn how to change the Azure SQL tier using SQL queries.
    Arkadeep De Feb 08, 2021
  • Abhijit Wagh

    How To Decide Whether To Use Delete Or Truncate In SQL Server

    While deleting data from a large SQL table, a question always comes to mind: what should we use? Delete or Truncate. With the contents published in this article, you can easily get your answer.
    Abhijit Wagh Jan 25, 2021
  • Rijwan Ansari

    Replace A String In SQL Server Table Column

    Sometimes, we might have a requirement to update or replace a particular string in an SQL table column.
    Rijwan Ansari Jan 15, 2021
  • Yogesh Kumar Hadiya

    Get Table Primary Key Column In SQL

    In this blog we will discuss how we can get primary column name of any table programmatically. However we can see primary column name by just right click on table and see design view. But when we h...
  • Darshan Shah

    Use Of DBCC Commands In SQL Server

    In this blog, you will learn a basic understanding and the use of DBCC commands in SQL Server.
    Darshan Shah Sep 18, 2020
  • Satya Karki

    Deployment Of An RDL Report File In SQL Report Server - SSRS Report

    In this blog, you will learn about the deployment or publishing methods of an RDL Report File in SQL Report Server.
    Satya Karki Sep 12, 2020
  • Vinay Talapaneni

    How To Find A String Repeated In Paragraph By Using SQL Server

    The simplest way to find the how many number of times the specific string repeated in paragraph.
    Vinay Talapaneni Aug 31, 2020
  • Vinay Talapaneni

    How To Split A String In SQL

    This blog explains how to split a string using recursive CTE in SQL.
    Vinay Talapaneni Aug 28, 2020
  • Gaurav Kumar Sharma

    Database Connection String MS-SQL Server - Easy Steps

    In this tutorial, we learn about how to create a database connection string for MS-SQL Server with simple steps.
  • Dave Bland

    A Faster Alternative To sp_helpdb

    This shows a faster alternative to get the same information as sp_helpdb
    Dave Bland Aug 19, 2020
  • Satya Karki

    Build A SSRS (RDL) Report From Microsoft Report Builder - Part Two

    In this blog, you will learn how to build a SSRS (RDL) report with a bar graph and a pie chart from Microsoft Report Builder.
    Satya Karki Aug 04, 2020
  • Satya Karki

    SQL Server Reporting Services(SSRS) | An Introduction

    In this blog, you will learn about Brief Introduction to SQL Server Reporting Services.
    Satya Karki Jul 28, 2020
  • Satya Karki

    Build SSRS (RDL) Report From Microsoft Report Builder - Part One

    This article describes how to build a SSRS(RDL) report from Microsoft Report Builder.
    Satya Karki Jul 27, 2020
  • Atul Warade

    Difference Between Union And Union All In SQL Server

    Here we try to understand the Difference between Union and Union All in Sql Server.
    Atul Warade Jul 15, 2020
  • Satya Karki

    Report Server Configuration Manager Setup For SQL Server Reporting Services (SSRS)

    In this article, you will learn how to configure the setup for SQL Server Reporting Services.
    Satya Karki Jun 15, 2020
  • Sagar Jaybhay

    Learn To Use Union, Intersect, And Except Clauses

    n this article, we will understand Union, Intersect, and Except clause in SQL Server. Also, we will see the difference between Intersect and Union in SQL Server. Also, the difference between Join w...
    Sagar Jaybhay May 07, 2020
  • Dave Bland

    Optimize For Ad Hoc Workloads, What Is It?

    This post will give a high-level overview of this setting.
    Dave Bland May 04, 2020
  • Raj Kumar

    Could Not Find Server 'Server Name' In sys.servers In SQL Server

    In this blog, you will learn how to resolve the error “Could not find server 'server name' in sys.servers” in SQL Server.
    Raj Kumar Apr 24, 2020
  • View More