Generally, when filling out Online forms, we don’t know what to fill in the particular columns. For example, the Email field will not be mandatory (which is an optional parameter)every time, so in the front end, the user skips it. That column will be taken as Null or not applicable in the system. Here, we … Read more >>
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 >>
Download A 40 pages PDF And Learn Now.