Bijay 
A week ago, while creating the stored procedure, my team required me to update a record in the table using the same. I updated it using the stored procedure concept. Here, I am sharing my real-time experience of how I did in my organization. Here, we will create a new stored procedure for updating and … Read more >>
Last week, my team required me to create a temporary table to store data for a short period of time. I created a Local temporary table and a global temporary table to store specific details for a specific time. Temporary tables will be temporarily available in the SQL Server. Once the connection is lost, the … Read more >>
Two days ago, while working on the SQL query, my manager asked me to get the output in table-valued format. I created a function for the table and showed the output. A function in SQL Server is nothing but giving the required output based on the user’s input. Whatever the inputs, the function or operation … Read more >>
Understanding the difference between stored procedure and function is important for developers and admins when working with SQL Server. Both are important for creating reusable SQL code, but they have different purposes and characteristics. The stored procedure doesn’t have parameters and no need to return any results, whereas the function will return values. We will … Read more >>
If you have encountered duplicate values in your table, here is a tutorial on how to delete duplicate rows in SQL Server. Duplicate values lead to insufficient database storage. I’ll explain the three methods to delete duplicate rows from a table in this SQL Server tutorial. Method 1: Find Duplicate Rows in the Table using … Read more >>
While working on the table from SQL Server Management Studio, I received the warning message that saving changes is not permitted. Since I have proper permissions to do DDL operations but still faced this error. After multiple troubleshooting techniques, I resolved this error. Here, I am sharing my real-time experience of solving this error. Let’s … Read more >>
I recently worked on SQL Query, where I needed to change employee roles and salaries in the EmployeeInfo table. Here, in SQL, we can easily use the Replace Function to make the changes. SQL Server Replace Function The replace () function in SQL is a built-in function that allows us to replace all the substrings within a … Read more >>
As an SQL Server data analyst, I recently received a requirement to add a few columns to an existing table. We can achieve this using the ALTER command. I have provided a few examples of how to add single and multiple columns (with different data types) to a table in SQL Server. I will also … Read more >>
As a database developer, I was working on the query and wanted to get the exact time of a system on which the SQL server is currently running; then, I could use the CURRENT_TIMESTAMP Function provided by the SQL Server. The CURRENT_TIMESTAMP() function returns the computer’s current time stamp in ‘YYYY-MM-DD hh:mm: ss.mmm’ format. This … Read more >>
While creating a function in the SQL query, I was required to convert integers into fixed-length strings in SQL Server. After multiple research studies, I found a simple and standard way of converting. In this SQL Server tutorial, you will learn how to convert int to fixed length string in SQL Server. You will understand … Read more >>
Download A 40 pages PDF And Learn Now.