Bijay Kumar Sahoo

After working for more than 15 years in the Software field, especially in Microsoft technologies, I have decided to share my expert knowledge of SQL Server. Check out all the SQL Server and related database tutorials I have shared here. Most of the readers are from countries like the United States of America, the United Kingdom, New Zealand, Australia, Canada, etc. I am also a Microsoft MVP. Check out more here.

SQL Server Convert Int to String Padding

by
SQL Server Convert Int to String Padding Left Padding

In this SQL Server tutorial, you will learn about SQL Server convert int to string padding where you will introduced to the concept of padding. After that, you will understand the LEFT(), RIGHT(), CONVERT(), and REPLICATE() functions that you can use these functions in combination to apply the left and right padding to the string. … Read more

Convert Int to String in Stored Procedure in SQL Server

by
Convert Int to String in Stored Procedure in SQL Server

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

How to Find Database Name in SQL Server Management Studio?

by
Find Database Name in SQL Server Management Studio Using Query

In this SQL Server tutorial, you will learn to find database name in SQL Server Management Studio. You will understand how to find the name of the database through Object Explorer in SSMS. After that, you will learn through examples how to find the name of a database using a query in SSMS. Find Database … Read more

How to Convert Int to String with Commas in SQL Server?

by
Convert Int to String with Commas in SQL Server

In this SQL Server tutorial, you will learn about SQL Server convert int to string with commas. I will show you how to use the CONVERT(), FORMAT(), and CAST() functions to convert integers to strings and format those strings with commas in SQL Server. SQL Server Convert Int to String with Commas There are two … Read more

Create Stored Procedure in SQL Server

by
Create Stored Procedure in SQL Server

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

How to Find Database Name in SQL Server Using Query?

by
Find Database Name in SQL Server Using Query

In this SQL Server tutorial, you will learn how to find database name in SQL Server using query. You will see about two methods that you can use to find the name of the database. Then, you will understand the situation where you can employ those methods. Find Database Name in SQL Server Using Query … Read more

How to Install SQL Server Management Studio?

by
Install SQL Server Management Studio Opening

In this SQL Server tutorial, you will learn to install SQL Server Management Studio for managing and maintaining the SQL Server databases. Here you will understand the step-by-step process to install the SSMS and also how to connect to the SQL Server instance in SSMS. Finally, you will be introduced to the nodes and their … Read more