Articles by Rohatash Kumar

Destructuring simplifies value extraction from objects/arrays. React's event handling enables dynamic responses to user interactions, crucial for interactive UIs. Components manage state/props, facilitating efficient UI development.

In this article, we will see how to create and remove a database in SQL Server 2012.

In this article, I am going to give a quick overview of temporary tables in SQL Server. local temporary table, global temporary table, drop temporary table.

Here, we will take a look at how to use Ranking Functions in SQL Server 2012. Learn ROW_NUMBER, RANK, DENSE_RANK, NTILE.

Here, we will see how to change the password visually and programmatically in SQL Server 2012.

Here, you will see how to perform insert, update, or delete operations on a target table based on the results of a join with a source table using a merge statement.

In this article, we will see how to use @@IDENTITY and SCOPE_IDENTITY() in SQL Server 2012.

In this article, we will see how to determine the second highest and Nth highest salary from a column in SQL Server 2012.

In this article, we will see how to use the cast and convert functions in SQL Server 2012.

In this article, we will see how to create a view programmatically in SQL Server 2012.

In this article, we will see how to create a view visually in SQL Server 2012.

Customizing menus and toolbars in SQL Server 2012, via SQL Server Management Studio, involves modifying shortcuts, adding or removing commands, and rearranging options to streamline workflow. This customization enhances user experience and efficiency within the SQL Server environment.

This article features the differences between the IsNull() and Coalesce() functions in SQL Server 2012.

In this article I will explain the use of the throw statement in SQL Server 2012.

Today, I have provided an article showing you how to Creating a user-defined type using visually or programmatically in SQL Server 2012.

Today, I have provided an article showing you how to handle deadlock in SQL Server 2012.

Today, I have provided an article showing you how to insert multiple values into a table using a single query in SQL Server 2012.

Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.

Today, I have provided an article showing you how to develop and design queries using the Query Designer in SQL Server 2012.

This article shows how to calculate the difference between two dates of the same column or in different columns in SQL Server 2012.

Today, I have provided an article showing you how to use a return value with a Stored Procedure in SQL Server 2012