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.

Videos

  • Creating A Database In SQL Server 2017 - A Quick Recap

    In this video session, we will quickly walk through the steps of creating a simple Database in SQL Server 2017 Express Edition.
  • Create Unique Key Constraint Through GUI In SQL Server

    Learn how to create a Unique Key Constraint in SQL Server through GUI without writing any T-SQL query.
  • Making Custom Function Deterministic With SCHEMABINDING And Its Impact On DB Objects

    In this video, we will learn to make custom functions or User-Defined Functions in SQL Server Deterministic by using the "SCHEMABINDING" keyword.
  • Creating Computed Columns With User Defined Functions

    In this video, we are going to learn about adding a computed column by using a user-defined function, also known as Custom Function. --Create a function (NON DETERMINISTIC) CREATE FUNCTION [dbo].[M...
  • Creating a Computed Column in SQL Server

    Learn to create a Computed Column in SQL Server through Management Studio GUI without writing T-SQL.
  • Generating SELECT (JOIN) Query Through Criteria Pane, SQL Pane, and Diagram Pane

    In this training video, we will learn how to generate SELECT (INNER JOIN) Query through Criteria pane, SQL Pane, and Diagram Pane. We will not write query ourselves; instead, we will use SSMS GUI t...
  • Dynamic Pivot Table In SQL Server

    In this video , we will learn how to create dynamic pivot table in SQL server in just 10 minutes
  • Introduction To SQL Server Pagination

    In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
  • Understanding SQL Server Transparent Data Encryption

    In this video, we will look into the encryption of SQL Server Database using TDE.
  • Introduction To SQL Server Dynamic Data Masking

    In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
  • 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.
  • Enabling SQLCLR in SQL2005

    This video shows enabling SQLCLR through, Surface area configuration tool.
  • Creating C# function and Deploying it as SQLServer Function

    This video shows creating a C# function and then deploying it in the SQL Server. After deployment, the function can be used as SQL Server built-in function.
  • Database Mirroring in SQL Server

    This video will give you a detailed explanation on how to configure SQL Server DB Mirroring.
  • Scalar-Valued SQL Function with Parameters

    This video shows writing a Scalar-Valued SQL Function that takes Parameter. The video also walks you through different parameter passing techniques
  • Creating Stored Procedure in SQL Server

    This article explain how to create Stored Procedure in SQL Server.
  • Retrieve Multiple Rows as a Single Record

    A simple way to join tables in order to pivot a multi-row structure on a single-row one
  • Video: Creating a stored procedure and executing it

    The video shows creating a stored procedure and executing it in the Management studio.
  • String Functions in SQL Server 2012: Part 1

    In this video you learn about some string functions in SQL Server 2012.
  • String Functions in SQL Server 2012: Part 3

    In this video you will learn about some commonly used string functions in SQL Server 2012.
  • View More