No new comments.
View All Comments
No new messages.
View All Messages
No new notifications.
View All Notifications
Request a new Category
No tag found
Refine by Author
Dhananjay Kumar (1)
No resource found
SQL Server: Use CASE in WHERE Clause
Apr 07, 2016.
In this article I am going to show how we can use CASE in WHERE clause.
SQL For Beginners - LIKE And IN Clause
Jan 19, 2016.
This article will help you understand the Like and In Clause of SQL.
SQL For Beginners - WHERE Clause
Jan 09, 2016.
This article will help you to learn the WHERE clause and expressions used with it.
Difference Between ROW_NUMBER () OVER () & PARTITION BY Clause
Jul 29, 2015.
In this article you will learn the difference between ROW_NUMBER(), OVER() and PARTITION BY clauses in SQL Server.
Output Clause in SQL Server
Jul 10, 2015.
In this article we will learn about output clauses in SQL Server.
OFFSET-FETCH Clause in SQL Server
Apr 06, 2015.
This article explains the OFFSET-FETCH clause that is a filltering option, like top, that can filter the data based on the number of rows.
SQL Query Performance - Functions and Indexes
Apr 02, 2015.
In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
Basic Terminology of SQL Server
Mar 17, 2015.
In this article we learn SQL from the basics. Here I describe all the basic terminology of SQL.
How to Show Group Rows Using Group By in SQL Server
Feb 18, 2015.
In this article we will see how to group rows using Group By and we will also see the difference between the Where and Having clauses.
OUTPUT Clause in SQL Server
Nov 15, 2014.
This article explains the OUTPUT keyword including the basic advantages of it.
Over Clause in SQL Server (Windows on Data) Part 2
Aug 28, 2014.
This article explains the over clause in SQL Server.
Over Clause in Sql Server (Windows on Data): Part 1
Aug 17, 2014.
This article explains how the Over clause works.
Capturing Changes in SQL Server Tables
Jul 30, 2014.
For capturing the changes of DML statements we must be familiar with the Merge statement and Output clause in SQL Server. I am giving a general overview of these statements.
Restriction and Projection Operator in LINQ
Jun 23, 2014.
In this article we will learn about the Restriction and Projection operators in LINQ, their syntax and their functionality with examples.
HAVING Clause In QlikView
Apr 28, 2014.
This article describes the introduction of a HAVING clause and also introduces how it is used.
GROUP BY Clause In QlikView
Apr 28, 2014.
This article prvides the basic concepts of the GROUP BY clause in QlikView applications.
Working With Having Clause in F#
Dec 02, 2013.
My previous article explaiined how to use Group by clause using Stored Procedure in Windows Forms application now I will describe in this article the Having Clause and how to use this clause in Windows in a Stored Procedure.
Grouping Database Records in Windows Form
Nov 29, 2013.
This article explains how to use the Group By clause in a Stored Procedure in a Windows Forms application.
Oracle SQL Commands: Part 9
Nov 12, 2013.
In this article you will learn about more Oracle commands.
Oracle SQL Commands: Part 6
Nov 07, 2013.
In this article you will learn about various select commands in Oracle.
Oracle SQL Commands: Part 7
Nov 07, 2013.
In this article you will learn about various Oracle commands.
Constraints in Oracle : Part 1
Oct 23, 2013.
This article explains the Constraint clause in Oracle that is basically used to apply the specific rules to the data that restrict the values/data entered into the database columns.
Transact SQL Query Performance Tuning Tips
Aug 09, 2013.
In this article, I will discuss some T-SQL query performance tips and tricks for SQL server programmers. The tips mentioned in this article may sound obvious to most of you, but I have seen professional developers who don't think before using them.
Merge Statement With DML Operations in SQL Server
Jul 10, 2013.
This article defines how to insert, update and delete records in a database table using the merge statement in SQL Server.
Some Important Tips For SQL Query Performane
Jul 01, 2013.
This article provides some important tips for SQL Query Performane.
Finding Duplicates Among Multiple Columns in SQL
May 15, 2013.
Here I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.
Find and Delete Duplicate Records From SQL Table
Apr 30, 2013.
In this article I explain how to count and delete duplicate records from SQL database table.
MySQL DISTINCT Operator in PHP
Apr 04, 2013.
In this article I will explain MySQL DISTINCT operator in PHP.
GROUPING SETS Clause in SQL Server
Feb 05, 2013.
In this article we explain the GROUPING SETS clause in SQL Server.
MySQL Where Clause in PHP
Jan 31, 2013.
I will describe in this article how to use the MySQL "where" clause in PHP.
Group By Clause in PHP
Jan 10, 2013.
In this article I explain how to use a MySQL "group by" clause in PHP.
Creating Check Constraint on a Table in SQL Server 2012
Dec 20, 2012.
This article will give you an idea of how to use the Check Clause and also defines where you can use it.
Select Query Using TOP WITH TIES Clause in SQL Server 2012
Dec 18, 2012.
In this article, I will explain the use of the TOP WITH TIES Clause in SQL Server.
Output Clause With Insert, Delete and Update Statement in SQL Server 2012
Dec 18, 2012.
This article will give you an idea of how to use the Output clause and also defines where you can use it.
On vs Where Clause in SQL Server 2012
Nov 27, 2012.
Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
Using Having Clause in SQL Server 2012
Nov 19, 2012.
In this article, I will try to highlight all the major points related to the Having clause in SQL Server.
Custom Paging in SQL Server 2012
Nov 13, 2012.
Microsoft SQL Server 2012 has a customized clause for paging and it is efficient. Custom paging is the option for handling huge records.
Select Query Using Like Clause in SQL Server 2012
Oct 19, 2012.
In this article we will see how to use the "like" Clause in a SQL Server database.
Select Data From XML With Where Clause Using LINQ to XML
Oct 16, 2012.
Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML.
A Simple Use of Case Statement in SQL Server 2012
Oct 09, 2012.
This article will give you an idea of how to use a Case expression in SQL Server.
Merge Statement in SQL Server 2012
Sep 12, 2012.
Here, you will see how to perform insert, update, or delete operations on a target table based on the results of a join with a source table using a merge statement.
How to Use Over Clause With Order By in SQL Server 2012
Aug 23, 2012.
In this article I am going to explain how to use an over clause with Order By in SQL server 2012.
Adding Subquery in a Select Statement in SQL Server 2012
Aug 17, 2012.
Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
Difference Between Throw Exception and Throw Clause
Aug 06, 2012.
In this article you will learn the differences between Throw Exception and the Throw clause.
Searching Record in Windows Store App Using LINQ
Jul 13, 2012.
Today we will create a search query operation in a windows store application with the help of LINQ.
Having and Alias Clause in MySQL
Dec 14, 2011.
In this article we learn the Having and Alias Clause in MySQL.
ORDER BY in MySQL
Dec 06, 2011.
In this article we learn the ORDER BY clause in MySQL.
Output keyword in Sql Server 2008
Nov 12, 2011.
In a simple word we can say OUTPUT clause used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements and also used for the auditing purpose.
Difference Between On Clause And Where Clause When Used With Left Join in SQL Server
Aug 04, 2011.
The purpose of this article is to show the difference between the On clause and Where clause when used with a left join in SQL Server.
Output Clause in SQL Server
Jun 16, 2011.
Here you will see the Output clause for SQL Server.
Grouping Sets in SQL Server 2008
May 05, 2011.
In this article I will describe grouping sets in SQL Server 2008 and the advantage of grouping sets compared to a simple Group by clause.
Output Clause and its Usage
Dec 28, 2010.
Output Clause is introduced in SQL Server 2005 version which is quite useful in various scenarios. It has access to Inserted and Deleted table which is also called the magic tables.
SQL Optimization Tips
Mar 31, 2010.
This article lists some of the optimization tips for SQL Server development.
Using OUTPUT Clause for Getting Deleting Information from Several Tables.
Apr 01, 2008.
In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!