In this SQL Server tutorial, you will learn how to generate stored procedure script file in SQL Server. You will understand about this script file and its benefits. Then, you will understand the syntax for the generated script file using the command line in sql server. In the end, you will use the SQL Server … Read more
In this SQL Server tutorial, I will show you how to execute a stored procedure in SQL server with a date parameter. You will be able to understand how to create a stored procedure that accepts the date values and returns the information from the table based on the given date ranges. Execute Stored Procedure … 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, 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, I will show you how to execute stored procedure for insert in SQL Server. You will understand how to create a stored procedure for inserting data and execute it using the query and SQL Server Management Studio. Execute Stored Procedure for Insert in SQL Server Before executing the stored procedure … 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, 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, 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
In this SQL Server tutorial, you will learn how to check database log file size in SQL Server using query. First, you will understand ‘What is a database log file in an SQL Server instance?’. Then you will understand about two view files sys.database_file and sys.master_files to retrieve the log file and its size. Check … Read more
In this SQL Server tutorial, you will learn how to get server name in SQ Server using query. In this tutorial, you will understand two configuration functions in SQL Server which help in finding the name of the SQL Server. Get Server Name in SQL Server using Query To get server name in SQ Server … Read more