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

  • Sudhir Kumar

    Triggers In SQL Server | SQL Interview questions and answers for freshers

    Understanding of triggers in SQL Server. Overview of trigger groups, magic tables, DML triggers with the use case, and real examples.A SQL Server trigger is like a stored procedure that executes ...
    Sudhir Kumar Sep 22, 2021
  • Onkar Sharma

    IIF Function In SQL Server

    This tutorial will show you the concept of IIF Function In SQL Server.
    Onkar Sharma Sep 20, 2021
  • Pankaj Patel

    The Complete Reference - Table Scan, Index Scan, And Index Seek

    In this article, you will learn about Table Scan, Index Scan, and Index Seek.
    Pankaj Patel Sep 16, 2021
  • Ganesan C

    Assembly In MS SQL Server

    In this article we are going to explore how to create custom CLR assembly and how to access it in the SQL Server.
    Ganesan C Sep 15, 2021
  • Onkar Sharma

    Difference Between HAVING And WHERE Clause In SQL Server

    This tutorial will show you the difference between the HAVING and WHERE Clause in SQL Server.
    Onkar Sharma Sep 06, 2021
  • Ashutosh Mund

    Export Blob(BINARY or VARBINARY) From SQL Table And Save It As A File

    In this blog, you will learn how to export Blob(BINARY or VARBINARY) From SQL Server Table and save it as a file.
    Ashutosh Mund Sep 06, 2021
  • Priyadarsini Tripathy

    Performance Tip And Tricks For SQL Sever DB Objects

    The idea of this blog is to share the leanings from the incidents which I have faced during my 8 years of experience with SQL Server which will help developers to write optimized SQL Query with les...
  • Vaidehi Pandere

    Cursors In SQL Server

    A SQL cursor is a database object that retrieves data from result sets one row at a time.The cursor in SQL can be used when the data needs to be updated row by row.
    Vaidehi Pandere Aug 18, 2021
  • 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 Aug 18, 2021
  • Onkar Sharma

    Different Ways To Handle NULL In SQL Server

    In this article, I have described various ways to handle NULL in SQL Server.
    Onkar Sharma Aug 12, 2021
  • John Morehouse

    How to put a SQL Server Database into Recovery Pending

    In this article I'll discuss how to put a SQL database into a Recovery Pending state.
    John Morehouse Jul 30, 2021
  • Darshan Shah

    SQL Server Express - Database Backup Scheduler

    In this blog we will learn how to take backup of database in SQL Server Express edition.
    Darshan Shah Jul 23, 2021
  • Praveen Kumar

    Get All Columns in a Table Schema Information In One Click

    Get Table All Columns Schema Information in One Click In this article, I will show how we can get table columns information like ColumnName, DataType, DataType Length, is mandatory, and column brie...
    Praveen Kumar Jul 22, 2021
  • Kirtesh Shah

    SQL Server Merge Statement

    In this article, you will learn about the SQL SERVER MERGE statement.
    Kirtesh Shah Jul 16, 2021
  • Monica Rathbun
  • Deepak Middha

    Triggers in SQL Server

    A SQL trigger is a database object just like a stored procedure or we can say it is a special kind of Stored Procedure that automatically fires when an event occurs in a database. Learn what is a t...
    Deepak Middha Jul 01, 2021
  • Rakesh Kalluri

    How To Reset Identity Column Values In SQL Server

    In this blog, you will learn how to reset an Identity Column Value in SQL Server.
    Rakesh Kalluri Jul 01, 2021
  • Pankaj Patel

    SQL Interview Questions - MSSQL

    Here is a list of the most popular MSSQL interview questions and answers explained. These SQL interview questions are for both beginners and professional MSSQL developers.
    Pankaj Patel Jul 01, 2021
  • Amit Kumar

    How To Check If A String Contains A Substring In SQL Server

    SQL contains string is used to check if a string contains a substring in SQL Server or not.
    Amit Kumar Jun 30, 2021
  • Bhavya Gaur

    Most Important SQL Commands

    In this article, you will learn about the most important SQL Commands.
    Bhavya Gaur Jun 28, 2021
  • Onkar Sharma

    How To Generate Scripts For Database Objects In SQL Server

    This tutorial will show you various methods to generate scripts for database objects in SQL Server 2019.
    Onkar Sharma Jun 25, 2021
  • Packiaraj Santhiyagu

    Auto Query Generator In MSSQL Server

    If you’re a developer, irrespective of the platform, you would have to work with Databases. Creating SQL statements for tables is quite often a monotonous job and it gets hectic especially with dea...
  • Ravinder Sharma

    Exists And Not Exists In SQL Server

    In this article we will explore the usage of Exists and Not Exists in SQL Server
    Ravinder Sharma May 22, 2021
  • Ravinder Sharma

    Full And Differential Backup Using SSMS

    In this article, we will see how to create a SQL Server Database backup. Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will...
    Ravinder Sharma May 19, 2021
  • Rajendran S

    How To Convert UTC Date To Any Given Timezone Name Date In SQL Server

    In this article, you will learn how to convert the UTC Datetime to any timezone using SQL.
    Rajendran S May 16, 2021
  • View More