Rohatash Kumar's contributions

Here, I have provided an article showing you how to create a user-defined type and rules in SQL Server.

In this blog, You will see how to swap two columns values in SQL Server.

Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.

In this blog, I have explained Common Table Expression in SQL Server.

Learn about the usage of the GO command and semicolon in SQL Server. Understand how to use GO as a batch separator and change it in SQL Server Management Studio. Semicolon (;) terminates SQL statements, especially useful for Common Table Expressions (CTEs). Explore practical examples and best practices in SQL Server 2012.

In this article I provide a quick overview of the various Queries to remove the first and last character from a string in SQL Server.

Learn about SQL Server tables like User, Temporary, Global; understand creation methods, differences between temporary and regular tables, storage locations, and utilization of table variables. Examples demonstrate creating and using these tables effectively.

SQL partition by. Learn how to use Row_Number function without Partition By in SQL or with Partition By in SQL. SQL Partition By Example.

In this article, I will try to highlight all the major points related to the Having clause in SQL Server.

QUOTENAME Function is used to add square brackets to the starting and ending of a string and how to store strings in various formats in SQL Server.

Here, we will have a look at how to use the Stuff and Replace functions in SQL Server 2012.

This article describes the most common uses of square brackets in SQL Server with examples.

In this article, I would like to show the most commonly used case expressions with update statements in SQL Server. 

This article contains the most commonly used global variables in SQL Server under a single article with examples.

In this blog, You will see how to generate Random Password in ASP.NET.

In this article, I would like to show how to get the name of all columns of a table in SQL Server.

Here, we will see use of Object Explorer to identify dependencies before changing or deleting an object or table.

In this article, I would like to show the new built-in function IIF in SQL Server. IIF is a shorthand way for writing a CASE statement.

In this blog, you will see how to use Ntile function in SQL Server.

In this article, you will see how to create a duplicate table with a new name using a script in SQL Server.

In this article, you will see some of the SQL Server System functions which provide information about database objects.

In this article, you will see how to use a Static Cursor in SQL Server.

In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.

In this article, we will see how to set up a full-text search index for SQL Server database.