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.

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 special …

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 where you can …

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 Table in SQL has …

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 result set …

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

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 contains rows with …

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 a couple …

The article explains how to get simple, practical and powerful SQL Queries using Grouping Sets, Rollup, Cube and Pivoting by means of detailed examples.

Group concatenation in T-SQL using CTE.