SQL Queries to Manage Hierarchical or Parent-child ... - CodeProject
Sep 16, 2014 · Download source - 35.7 KB Introduction Here, in this post, we will try to manage data with hierarchical relation or parent-child relation of a specific table in SQL server. Our …
Execute SQL Query on Mutiple SQL Servers or Databases
Jun 3, 2015 · In this blog we would learn how to execute a SQL Query on multiple databases of single DB Server or on a single Database on multiple DB Servers.
Making OUTER and CROSS APPLY work for you - CodeProject
Jun 16, 2013 · OUTER and CROSS APPLY are unique to SQL Server so this article is intended for anybody using SQL in a SQL Server environment. It will also cover many examples of …
SQL - Pivot with Grand Total Column and Row - CodeProject
Jul 27, 2011 · Introduction Microsoft SQL Server has introduced the PIVOT and UNPIVOT commands as enhancements to T-SQL with the release of Microsoft SQL Server 2005. Pivot …
LINQ Group By with NULL Database Values - CodeProject
LINQ Group By with NULL database valuesTuxCare’s Annual Open Source Survey is here! Share your opinions and help inform our yearly report. → Start Survey
Understanding Complex MySQL JOIN - CodeProject
Nov 20, 2013 · Download sql_join.zip - 2.5 KB Introduction The purpose of this article is to show the power of MySQL JOIN operations, Nested MySQL Queries (intermediate or temporary …
Counting Consecutive Dates Using SQL - CodeProject
How to count consecutive dates using SQLTuxCare’s Annual Open Source Survey is here! Share your opinions and help inform our yearly report. → Start Survey
Correlated Subqueries in SQL - CodeProject
Mar 8, 2022 · Correlated subqueries are used to tie an inner query’s criteria to values within the outer query. They are a powerful technique to avoid “hard coding” values. In this article, look at …
Handling NULL in T-SQL - CodeProject
Oct 5, 2014 · NULL is the smallest value in the sorting order. NULL in Group By NULL s are considered to be equal when the group by is executed. If a column in the GROUP BY clause …
Take maximum advantage of Grouping Sets, Rollup, Cube and …
The article explains how to get simple, practical and powerful SQL Queries using Grouping Sets, Rollup, Cube and Pivoting by means of detailed examples.