In this SQL Server tutorial, I will show you how to give permission to execute stored procedure in SQL Server. You will understand why giving execute permission on the stored procedure is necessary with examples. Then, understand the syntax that you can use to give execute permission. After that, I will demonstrate through query and … Read more
In this SQL Server tutorial, you will learn how to resolve the error cannot find the user because it does not exist or you do not have permission. You will understand the two reasons which are responsible for that error. Then, you will learn how to solve that error using the query and SQL Server … Read more
In this SQL Server tutorial, you will learn how to create stored procedure in SQL Server. Where I will explain the basic syntax for creating a store procedure and why we need to create a stored procedure in Microsoft SQL server. After that, you will understand with an example of how to create, view, and … Read more
In this SQL Server tutorial, you will learn how to convert int to string in stored procedure in sql server. Here, I will explain how to create a stored procedure using the CONVERT() and CAST() functions. Also, I explain to you some of the scenarios where you will required to convert int to string. SQL … Read more
In this SQL Server tutorial, I will show you how to format number with commas and decimal in SQL Server. In particular, you will learn about the SQL Server FORMAT() function that helps in formatting the given numbers based on the provided format pattern. You can format the number with different format patterns, but here, … Read more
In this SQL Server tutorial, you will learn how to create a table in SQL Server Management Studio using query. You will understand the concept of a table in SQL Server and then understand how to open the query editor in SQL Server Management Studio, where you can run the query. After that, you will … Read more
In this SQL Server tutorial, I will show you how to create temporary table in SQL Server Management Studio. First, you will understand ‘What is the temporary table?’, then you learn why a temporary table is created. After that, I will explain the types of temporary tables that you can create in SQL Server. Finally, … Read more
In this SQL Server tutorial, I will show you how to create a database in SQL server using query. You will understand the syntax to create a database in SQL Server. Also, you will learn about where to execute SQL Query on SQL Server Management Studio. Finally, you will create a database with examples. Create … Read more
In this SQL Server tutorial, you will learn how to create a database in SQL Server Management Studio. The SQL Server Management Studio is a tool or integrated environment provided by Microsoft to manage and work with SQL Server databases. So, in this tutorial, I will show how to create a database using SQL Server … Read more
In this SQL Server tutorial, you will learn how to check database size in SQL Server using query. You will understand the stored procedure in SQL Server that contains information about the databases and how to check the size of databases. Also, you will understand about view files in SQL Server to retrieve the database … Read more