Rohatash Kumar's contributions

This article will give you an idea of how to use the magic table and also defines where you can use it.

In this blog, we will see how to display a pyramid in C#.

Here, I have provided an article showing you how to utilize the two new logical functions Choose and IIF in SQL Server.

This article will give you an idea of how to use SQL Cascading Constraint and also defines the situations where you can use it.

This article will give you an idea of how to use formula child property of computed column specification property in SQL Server.

This article will give you an idea of how to use a Case expression in SQL Server.

This article demonstrates how to generate script in SQL Server database.

Here, you will see how to use mathematical numeric functions in SQL Server, including how to round values.

In this article, we covered system date and time in-built functions such as Sysdatetime, Sysdatetimeoffset, Sysutcdatetime, Getdate etc that returns the current date and time from the SQL Server.

Here, you will see the DateName function that represents the specified datepart of the specified date such as day, month, year, quarter, hour, minute in SQL Server.

This article demonstrates use of predicates with SQL queries in a SQL Server database.

In this article, I will show you how to use the Charindex and Patindex functions to search text columns and character strings.

In this article, we will see how to call a function from a stored procedure in SQL Server.

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.