In this SQL Server tutorial, I will show how to use the CONVERT function in SQL Server. Where you will see how to use the CONVERT() function to convert the data type of the value to another data type in an explicit way. Also, you will learn how to apply the CONVERT() function on the … Read more
In this SQL Server tutorial, you will learn about the CAST function in SQL Server, where you will understand how to cast or transform the datatype of the value to another datatype. Finally, you will learn how to implement the CAST() function on the column of the table, also how to concatenate the CAST() function … Read more
In this SQL Server tutorial, you will learn how to format numbers to 2 decimal places in SQL Server. You will use the different functions in SQL Server to format the number with 2 decimal places. Also, you will be introduced to the syntax of each function that you are going to use in this … Read more
In this SQL Server tutorial, you will learn about format numbers with leading zeros in SQL Server. First, you will be introduced to the concept of leading zero, and then how it is beneficial in several ways. After that, you will learn how to use the FORMAT() function to format the number with leading zeros. … Read more
In this SQL Server tutorial, you will learn how to format number with commas in SQL Server. Where you will understand how to use FORMAT() function to format the number. Also, you will use the different format specifier with the FORMAT() function to format the value with commas. Format Number with Commas in SQL Server … Read more
In this SQL Server tutorial, I will show you how to check autogrowth in SQL Server using query. In this tutorial, you will learn how to use the sys.master_files system view to check the autogrowth of a database and all the databases on the SQL Server. Also, use the sp_MSforeachdb and sp_helpfile system procedures to … Read more
In this SQL Server tutorial, you will understand how to check database table size in SQL Server. Where you learn about the different system procedures or views to check the size of each table within any database. Also, you will see how to use SQL Server Management Studio to check the table size. Check Database … Read more
In this SQL Server tutorial, you will learn how to get all stored procedure scripts in SQL Server using command line. You will use the SQLCMD utility in your command line and execute the query to get the script of all the stored procedures in your database. Then, you will understand how to use the … Read more
In this SQL Server tutorial, I will show you how to get all stored procedure scripts in SQL Server using query. First, I will explain to you the script in the context of SQL Server and what kind of data it stores. After that, with an example, you will understand how to retrieve or get … Read more
In this SQL Server tutorial, I will show you how to get all database size in SQL Server using query. In this tutorial, you will use the sp_helpdb stored procedure and sys.master_files view to retrieve the size of all the databases on the SQL Server. Get All Database Size in SQL Server Using Query To … Read more