A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats a sub-query as a virtual table for the execution of the query. A sub-query can be used as a table in a join statement, as a single value in a select statement, in the where clause of a SQL Server query, in the having clause of a SQL Server query, or incorporated in data manipulation statements.
So, you're a Microsoft SQL Server administrator flirting with open source, but you're not sure how far you should go on the first migration? Don't worry, there won't be much peer pressure to go "all the way." Look around and you'll find that most businesses making the switch are going only as far as their Web applications.
After he worked on the XML features of SQL Server 2005, he has moved on to Reporting Services. John Gallardo is an interesting person with a variety of thoughts on XML and more.
A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.
Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger.
In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.
As a DBA you might not need to build connection strings for your servers very often, but developers certainly need to build these all the time and might contact you for help. Author Raj Vasant takes a look at the new capabilities of .NET 2.0, which can really help make this easier.
In this video, you'll see how to use the SQL Server Integration Services Fuzzy Lookup Transform to match data that may've been mistyped. Use this transform to stop data duplication.
Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system.
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers