Loading
Rohatash Kumar's contributions
Customize Menu and Toolbar in SQL Server 2012
Customizing menus and toolbars in SQL Server 2012, via SQL Server Management Studio, involves modifying shortcuts, adding or removing commands, and rearranging options to streamline workflow. This customization enhances user experience and efficiency within the SQL Server environment.
Differences Between IsNull() and Coalesce() Functions in SQL Server 2012
This article features the differences between the IsNull() and Coalesce() functions in SQL Server 2012.
Offset and Fetch Next Keywords in SQL Server 2012
In this article I will explain the use of the new keywords OFFSET and FETCH NEXT in SQL server 2012.
Throw Statement in SQL Server 2012
In this article I will explain the use of the throw statement in SQL Server 2012.
Creating a User-Defined Type Using Visually or Programmatically in SQL Server 2012
Today, I have provided an article showing you how to Creating a user-defined type using visually or programmatically in SQL Server 2012.
Deadlock in SQL Server 2012
Today, I have provided an article showing you how to handle deadlock in SQL Server 2012.
Enhanced Execute Keyword in SQL Server 2012
Today, I have provided an article showing you an improved version of the execute keyword in SQL Server 2012.
Insert Multiple Values in Table Using Single Query in SQL Server 2012
Today, I have provided an article showing you how to insert multiple values into a table using a single query in SQL Server 2012.
Adding Subquery in a Select Statement in SQL Server 2012
Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
Developing and Designing Queries Using Query Designer in SQL Server 2012
Today, I have provided an article showing you how to develop and design queries using the Query Designer in SQL Server 2012.
Calculate Difference Between Two Dates in SQL Server 2012
This article shows how to calculate the difference between two dates of the same column or in different columns in SQL Server 2012.
New Date and Time (Built-in Functions) Functions in SQL Server 2012
Today, I have provided an article showing you how to use the new Date and Time functions in SQL Server.
Stored Procedure With a Return Value in SQL Server 2012
Today, I have provided an article showing you how to use a return value with a Stored Procedure in SQL Server 2012
User-Defined Sequence Object in SQL Server 2012
Today, I have provided an article showing how to use Sequence Object in SQL Server 2012. In this article we have also covered the difference between sequence and identity.
New Logical Functions in SQL Server 2012
Today, I have provided an article showing you how to utilize the two new logical functions Choose() and IIF() in SQL Server 2012.
New Data Type Conversion Functions in SQL Server 2012
Today, I have provided an article showing how to utilize the new data type conversion Functions in SQL Server 2012.
Move a Database Using Detach and Attach in SQL Server 2012
This article introduces how to Detach and Attach a database in SQL Server 2012 by using SQL Server Management Studio.
Issue While Achieve Method Overloading in WCF
Here I am creating a WCF service to describe method overloading with name the property of the OperationContract attribute.
Issue While Returning DataTable Through WCF Service
Today, I have provided an article showing you how to return a datatable using a WCF service from C# code.
Insert, Update and Delete Data With DataGridView in Windows Form Using WCF Service
Learn how to perform Insert, Edit, Update, and Delete operations in a DataGridView using a WCF Service in C#. This tutorial covers creating a SQL Server database table, implementing a WCF Service with CRUD operations, and integrating it into a Windows Forms Application. Ideal for beginners using Visual Studio 2010 and SQL Server 2008.
WCF Service to Connect Between Windows Forms Application and SQL Database
Today, I have provided an article showing you how to insert and display data in a DataGridView control using a WCF service from C# code.
Insert, Update and Delete Data in GridView Using WCF Service
Today, I have provided an article showing you how to insert, delete and update data in a GridView using a WCF service from C# code.
Insert Data Into SQL Server Database Using WCF Service
This article introduces how to insert data into SQL Server using a WCF service from C#.
Concept of Exists Condition in SQL Server
Learn how to use EXISTS and NOT EXISTS in SQL Server to filter rows based on matching or nonmatching records in another table.
Retrieving User Password and Email Address From Database Using C#
Today, I have provided an article showing you how to retrieve a user's password and email address from a database in ASP.NET.
