Articles by Rohatash Kumar

In this article, I would like to show the functions Datepart, DateName, Year, Month and Day in SQL Server.

In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.

Learn how to create a custom menu bar and dropdown menu in a Windows Forms application using the ToolStrip control.

In this article I provide a quick overview of how to use Filter Setting in SQL Server.

In this article I provide a quick overview of how to use the right and left functions in SQL Server.

In this article, I provide a quick overview of how to add a number in a string in SQL Server.

In this article, I would like to show how to get the name of the server and databases in SQL Server.

In this article, I would like to show how to restore a SQL Server Backup file in C#.

In this article, I would like to show how to create SQL Server Backup file in C#.

In this article, I would like to show the utility of Getdate functions in SQL Server.

Today, I have provided an article showing you the Len and DataLength methods in SQL Server.

Today, I have provided an article showing you Query, Node and Exist methods with XML type variable in SQL Server.

In this article, I am showing you how to display return value from stored procedure output parameter in Query Window in SQL Server 2012.

This article explains how to perform database backup compression in SQL Server 2012 using SQL Server Management Studio or a Transact-SQL statement. It provides a step-by-step guide to visually create a backup, select a destination, and choose compression options, ensuring an efficient backup process.

This article provides a brief introduction to various system Stored Procedures in SQL Server.

Here, I am going to explain some basics of UNICODE data types and functions in SQL Server.

This article will give you an idea of how to join three or more tables and also defines the join in SQL Server.

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.