In this SQL Server tutorial, we will learn How to get list of users, How to get a list of objects available in SQL Server. We will also demonstrate these topics with the help of examples. How to get list of users in SQL Server In this section, we will understand how to fetch all the … Read more >>

In this SQL Server tutorial, we will learn How to check if SQL Server is running or not. We will also discuss how we can check the status of different SQL Server services like an agent, browser, etc. And we will also illustrate the following topics given below. Note:- For all the demonstrations in the … Read more >>

In this sql server tutorial, we will discuss how to fix error, the remote procedure call failed sql server configuration manager. the remote procedure call failed sql server configuration manager A few days back I got an error while using SQL Server Configuration Manager to list the services. The error states “The remote procedure call … Read more >>

In this tutorial, we are going to learn about SQL Server stored procedure case statement. Here we will discuss how to use a CASE statement in SQL Server Server Stored Procedure. And we will also discuss the following topics. But before understanding how to use a CASE statement in a stored procedure, we should know what … Read more >>

In this SQL Server tutorial, we will understand how to delete a view in SQL Server. Additionally, we will also cover the following related topics. How to delete a view in SQL Server Before understanding the methods to delete a view in SQL Server, we have to discuss a few things. First, we need to understand the required … Read more >>

In this SQL Server tutorial, you will get to know about the various logical operators in SQL Server. I will explain how to use the logical operators with the help of some examples. Different logical operators return different outputs. Let us see what are the various logical operators and how to use them. List of … Read more >>

In this SQL Server tutorial, we will learn how to insert a row in a view in SQL Server. Additionally, we will also cover the following set of topics. Can we insert data into view in SQL Server In SQL Server, a VIEW is just like a virtual table that holds data from one or more than … Read more >>

In this SQL Server tutorial, we will learn how to use and create a temp table in stored procedure in SQL Server. Moreover, we will also illustrate the following set of topics. Here we are using SQL Server 2019 and SQL Server Management Studio. Create temp table in stored procedure in SQL Server As the name indicates, a temp table … Read more >>

In this SQL Server tutorial, we will learn and comprehend how to use the SQL Server Create Trigger If Not Exists statement. We will discuss and learn several instances to assist you in better understanding the concept. The full list of topics we will cover is given below. Also, check the latest related tutorial: SQL Server Trigger On View … Read more >>

As a database developer, it is important to keep the proper name for the stored procedure to understand and manage the database. In this SQL Server tutorial, we will discuss some of the naming conventions used for the stored procedures in SQL Server. Also we will see SQL Server stored procedure best practices. SQL Server Stored … Read more >>