Rohatash Kumar's contributions

In this article, I would like to show the difference between two dates in years, months and days in SQL Server.

This article describes how to enable FILESTREAM by using SQL Server Configuration Manager.

This article demonstrates how to copy a table with data from one database to another in a SQL Server database.

This article will give you an idea of how to add columns of two tables into one column and also defines how to handle a null value in SQL Server.

This article will give you an idea of how to use the SQL Server Check Clause and also defines where you can use it.

In this article, I will explain the use of the TOP WITH TIES Clause in SQL Server.

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

In this article I will explain the NULL value with IsNull() and Coalesce() functions in SQL Server.

In this article, you will see some of the SQL Server Error functions which provide information about the error.

In this article, I would like to show the functions Month and Eomonth in SQL Server.

This SQL Server tutorial explores the Datepart function, a built-in function for extracting portions of a DateTime field, demonstrated through practical examples for various date and time components.

In this article, I would like to show the Dateadd Function in SQL Server.

In this article, we will see how to modify the data of an underlying base table in SQL Server using a View.

In this article, I describe how to pass a table to a function parameter in SQL Server.

In this article, I described how to pass a table to a Stored Procedure parameter in SQL Server.

In this article, I described how to use the ReadText and WriteText statements in SQL Server.

In this article, I described how to calculate the maximum range of various integer data types in SQL Server. TINYINT, SMALLINT, INT and BIGINT are all number data types. The difference between these data types are in the minimum and maximum values. So let's have a look at a practical example of how to calculate the maximum range of the integer data type in SQL Server. The example is developed in SQL Server 2012 using the SQL Server Management Studio.

In this article, I would like to show the new built-in function Lead in SQL Server.

In this article, I would like to show the new analytic functions First_Value and Last_Value in SQL Server.

In this article, you will see the SQL aggregate function count in two forms, Count All and Count Distinct.

This article will give you an idea of how to use the space function in SQL Server.

Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.

In this blog, You will see how to use DBCC CHECKIDENT in SQl Server.