Articles by Rohatash Kumar

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 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 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.

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

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.