Resources No resource found - Understanding Guard Clauses in C#Jan 01, 2024. Guard clauses are an essential aspect of writing clean, readable, and robust code in C#. They serve as initial validation checkpoints at the beginning of a method, ensuring that the method is executed only when the incoming parameters meet certain criteria. Guard clauses help in the early detection of invalid inputs or conditions, preventing further execution of the method and reducing the chances of unexpected errors.
- Guard Clauses in C#Dec 12, 2023. What are guard clauses? How do they implement them in . NET? There are multiple ways of implementation. How are they different from validation?
- How To Work with JSON in SQL Server?Aug 08, 2023. In this article, we will learn about How To Work with JSON in SQL Server
- Early Return Pattern in C#Jul 28, 2023. We will have an overview of the early return pattern and some examples in C#
- How To Use LIMIT in MySQL?Jun 20, 2023. The LIMIT clause is used to limit the number of rows returned by a SELECT statement in MySQL. It is typically used in combination with the ORDER BY clause to specify the order in which the rows should be returned. The syntax for the LIMIT clause is as follows.
- SQL Where StatementMay 10, 2023. In this article we will discuss about SQL Where statement
- Elasticsearch Boolean QueriesJan 12, 2023. In this article, we will see how to write Boolean queries and how it is working in Elasticsearch.
- Using For XML Clause In SQL QueriesMay 05, 2022. For XML clause is used to convert the SQL result set into XML format. It is a very much helpful clause when we need XML data from the SQL result set. The FOR XML clause can be used in top-level queries and in subqueries. The top-level FOR XML clause can be used only in the SELECT statement. In sub queries, FOR XML can be used in the INSERT, UPDATE, and DELETE statements. 
- Quick Tip - Remove CONVERTS/CASTS From WHERE/JOIN ClausesMar 29, 2022. In this article, you will learn how to remove CONVERTS/CASTS from WHERE/JOIN clauses.
- Difference Between HAVING And WHERE Clause In SQL ServerSep 06, 2021. This tutorial will show you the difference between the HAVING and WHERE Clause in SQL Server.
- SQL - Order By ClauseJun 15, 2021. In this article, you will learn about SQL "Order By" Clause.
- Create Dynamic Pivot Table Using Store ProcedureJan 18, 2021. In this article I will tell you how we can create dynamic pivot table using pivot clause and store procedure. In this article we will create a store procedure which takes some parameter and generate pivot table.
- Zero To Hero In MS SQL Server - Part SixSep 17, 2018. In this article, I have shared some knowledge on WHERE CLAUSE and Update SQL Statement.
- How To Use Joins, and Group By Clause In Entity Framework With LINQ C#Jul 15, 2017. In this article will be going to learn How to use Joins, and Group By Clause in Entity Framework with Linq C#
- SQL Server: Use CASE in WHERE ClauseApr 07, 2016. In this article I am going to show how we can use CASE in WHERE clause.
- SQL For Beginners - LIKE And IN ClauseJan 19, 2016. This article will help you understand the Like and In Clause of SQL.
- SQL For Beginners - WHERE ClauseJan 09, 2016. This article will help you to learn the WHERE clause and expressions used with it.
- Difference Between ROW_NUMBER () OVER () & PARTITION BY ClauseJul 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 ServerJul 10, 2015. In this article we will learn about output clauses in SQL Server.
- OFFSET-FETCH Clause in SQL ServerApr 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.
- Basic Terminology of SQL ServerMar 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 ServerFeb 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 ServerNov 15, 2014. This article explains the OUTPUT keyword including the basic advantages of it.
- Over Clause in SQL Server (Windows on Data) Part 2Aug 28, 2014. This article explains the over clause in SQL Server.
- Over Clause in Sql ServerAug 17, 2014. SQL Over. This article explains how SQL Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005.
- Restriction and Projection Operator in LINQJun 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 QlikViewApr 28, 2014. This article describes the introduction of a HAVING clause and also introduces how it is used.
- GROUP BY Clause In QlikViewApr 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.
- Oracle SQL Commands: Part 9Nov 12, 2013. In this article you will learn about more Oracle commands.
- Oracle SQL Commands: Part 6Nov 07, 2013. In this article you will learn about various select commands in Oracle.
- Oracle SQL Commands: Part 7Nov 07, 2013. In this article you will learn about various Oracle commands.
- T-SQL Query Performance Tuning TipsAug 09, 2013. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
- Merge Statement With DML Operations in SQL ServerJul 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 PerformanceJul 01, 2013. This article provides some important tips for SQL Query Performance.
- Find and Delete Duplicate Records From SQL TableApr 30, 2013. In this article I explain how to count and delete duplicate records from SQL database table.
- MySQL DISTINCT Operator in PHPApr 04, 2013. In this article I will explain MySQL DISTINCT operator in PHP.
- GROUPING SETS Clause in SQL ServerFeb 05, 2013. In this article we explain the GROUPING SETS clause in SQL Server.
- MySQL Where Clause in PHPJan 31, 2013. I will describe in this article how to use the MySQL where clause in PHP.
- Group By Clause in PHPJan 10, 2013. In this article I explain how to use a MySQL group by clause in PHP. The group clause is used to group the rows of a result set based on one or more column expressions. Group by clause determines how the selected rows are grouped. The group by clause follows the where clause.
- Creating Check Constraint on a Table in SQL Server 2012Dec 20, 2012. This article will give you an idea of how to use the SQL Server Check Clause and also defines where you can use it.
- Output Clause With Insert, Delete and Update Statement in SQL Server 2012Dec 18, 2012. This article will give you an idea of how to use the Output clause and also defines where you can use it.
- Select Query Using TOP WITH TIES Clause in SQL Server 2012Dec 18, 2012. In this article, I will explain the use of the TOP WITH TIES Clause in SQL Server.
- On vs Where Clause in SQL Server 2012Nov 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 2012Nov 19, 2012. In this article, I will try to highlight all the major points related to the Having clause in SQL Server.
- Select Query Using Like Clause in SQL Server 2012Oct 19, 2012. In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.
- Select Data From XML With Where Clause Using LINQ to XMLOct 16, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. Select Data From XML With Where Clause Using LINQ to XML.
- A Simple Use of Case Statement in SQL Server 2012Oct 09, 2012. This article will give you an idea of how to use a Case expression in SQL Server.
- Merge Statement in SQL Server 2012Sep 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 2012Aug 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 2012Aug 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 ClauseAug 06, 2012. In this article, you will understand the difference between 'throw exception' and 'throw clause' is essential for effective error handling. While 'throw exception' generates and propagates a new exception object, 'throw clause' simply rethrows the current exception, maintaining its original state.
- Searching Record in Windows Store App Using LINQJul 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 MySQLDec 14, 2011. In MySQL, the HAVING and AS (Alias) clauses are powerful features used in conjunction with the SELECT statement to filter and rename data retrieved from a table. Let's look at each clause individually.
- Difference Between On Clause And Where Clause When Used With Left Join in SQL ServerAug 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 and its UsageDec 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#.