Question of the Day

Log in to test your SQL Server knowledge with daily questions.

Blogs

Finding fields used in a Power BI report in PBIR format with Semantic Link Labs

By

Have you ever wondered where a certain field is used in a report? Or...

Adding Test data to msdb.sysjobhistory

By

One of our internal people was looking to test some process in (I assume)...

Microsoft Ignite Announcements Nov 2024

By

Announced at Microsoft Ignite last week were some new product features related to the...

Read the latest Blogs

Forums

A Strange Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Strange Query

Primary and Secondary Filegroup

By nshete

Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...

Import data from json file with special characters

By don075

I am using the following script to import data from a json file. This...

Visit the forum

Question of the Day

A Strange Query

What does this return? 

SELECT x=1 
WHERE (SELECT 1) IN ( 1, 2, 3)

See possible answers