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

  • Dharmraj Thakur

    How to Generate Alter Script of Table Design Mode - Sql Server Management Studio

    How to generate the alter table SQL script in using SSMS.
    Dharmraj Thakur Nov 13, 2019
  • Artur M

    T-SQL - Introduction To Window Functions

    You can optimize your queries to obtain simple and elegant solutions to a variety of problems by using Window Functions in T-SQL. In this video tutorial, let us learn how.
    Artur M Aug 29, 2019
  • Artur M

    T-SQL For Beginners

    T-SQL (Transact-SQL) is a Microsoft extension to the SQL (Structured Query Language). T-SQL is central to using Microsoft SQL Server. In this course, you will learn the basics of this language in a...
    Artur M Aug 13, 2019
  • Nilesh Sawardekar

    Resolving Microsoft SQL Management Studio Package Failed To Load Error

    In this video, you will get to know how to resolve the error - 'Microsoft SQL Management Studio Package' failed to load.
    Nilesh Sawardekar Aug 13, 2019
  • Nirav Gandhi

    SQL Assessment API (Public Preview)

    Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.
    Nirav Gandhi Aug 06, 2019
  • Zia Ahmed Shaikh

    Understanding Foreign Key Through GUI In SQL Server

    In this video tutorial, we will learn how we can create a Foreign Key in a child table referencing its parent table. And, we will try to understand the concept of foreign keys through GUI.
    Zia Ahmed Shaikh Feb 18, 2019
  • Zia Ahmed Shaikh

    Use Of DISTINCT Keyword In T-SQL (SQL Server)

    In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.
    Zia Ahmed Shaikh Feb 05, 2019
  • Zia Ahmed Shaikh

    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.
    Zia Ahmed Shaikh Oct 24, 2018
  • Zia Ahmed Shaikh

    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.
    Zia Ahmed Shaikh Oct 16, 2018
  • Zia Ahmed Shaikh

    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.
    Zia Ahmed Shaikh Aug 11, 2018
  • Zia Ahmed Shaikh

    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...
    Zia Ahmed Shaikh Aug 10, 2018
  • Zia Ahmed Shaikh

    Creating a Computed Column in SQL Server

    Learn to create a Computed Column in SQL Server through Management Studio GUI without writing T-SQL.
    Zia Ahmed Shaikh Aug 02, 2018
  • Zia Ahmed Shaikh

    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...
    Zia Ahmed Shaikh Aug 02, 2018
  • Dinesh  Kushwaha

    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
    Dinesh Kushwaha Apr 16, 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
  • 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
  • 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
  • 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
  • Sivaraman Dhamodaran

    Enabling SQLCLR in SQL2005

    This video shows enabling SQLCLR through, Surface area configuration tool.
  • Sivaraman Dhamodaran

    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.
  • View More