Loading
Rohatash Kumar's contributions
New Functions in SQL Server 2012
In this article I will be covering the most commonly used new functions in SQL Server 2012.
Creating Subquery in SQL Server
This article shows how to create a subquery to a select statement in SQL Server.
New Parse Conversion Function in SQL Server 2012
In this article you will see how to use conversion functions using SQL Query in SQL Server.
Getting Date and Time Values From Their Parts in SQL Server 2012
Learn how to construct date, time, and datetime values from individual parts using DATEFROMPARTS, TIMEFROMPARTS, and DATETIMEFROMPARTS in SQL Server 2012.
Modifying Date and Time Values in SQL Server
In this article, I would like to show the functions DATEADD, EMONTH, TODATETIMEOFFSET in SQL Server.
Getting Date and Time Parts From DateTime in SQL Server
In this article, I would like to show the functions Datepart, DateName, Year, Month and Day in SQL Server.
Working with Date and Time in SQL Server
In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.
Adding Custom Menu in Windows Forms Application
Learn how to create a custom menu bar and dropdown menu in a Windows Forms application using the ToolStrip control.
Using Filter Settings Option in SQL Server
In this article I provide a quick overview of how to use Filter Setting in SQL Server.
Using Right and Left Function in SQL Server
In this article I provide a quick overview of how to use the right and left functions in SQL Server.
Adding a Number in String in SQL Server
In this article, I provide a quick overview of how to add a number in a string in SQL Server.
Getting the Name of the Server and Databases in SQL Server
In this article, I would like to show how to get the name of the server and databases in SQL Server.
Restore SQL Server Backup File With C#
In this article, I would like to show how to restore a SQL Server Backup file in C#.
Creating SQL Server Backup File With C#
In this article, I would like to show how to create SQL Server Backup file in C#.
Getting Some Useful Date and Time Information From Getdate Function in SQL Server 2012
In this article, I would like to show the utility of Getdate functions in SQL Server.
LEN and DATALENGTH Function in SQL Server 2012
Today, I have provided an article showing you the Len and DataLength methods in SQL Server.
Some Important XML Data Type Methods in SQL Server 2012
Today, I have provided an article showing you Query, Node and Exist methods with XML type variable in SQL Server.
Display Stored Procedure Output Parameter Value With Query Window in SQL Server 2012
In this article, I am showing you how to display return value from stored procedure output parameter in Query Window in SQL Server 2012.
Database Backup With Compression in SQL Server
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.
New FileTables Feature in SQL Server 2012
In this article you will have a look at how to use the FileTable feature of SQL Server 2012
Some Useful System Stored Procedures in SQL Server 2012
This article provides a brief introduction to various system Stored Procedures in SQL Server.
UNICODE and NCHAR Functions in SQL Server 2012
Here, I am going to explain some basics of UNICODE data types and functions in SQL Server.
Joining Three or More Tables in SQL Server 2012
This article will give you an idea of how to join three or more tables and also defines the join in SQL Server.
OPENXML Function in SQL Server 2012
In this article, I would like to explain the Openxml System function and the use of it in SQL Server.
