Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
702 reads
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
4,515 reads
This month’s T-SQL Tuesday is hosted by Matthew McGiffen. His challenged is to come up with a puzzle. My entry involves a simple request that is more difficult to...
2019-05-14
This post is a response to this month’s T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
The...
2019-05-14
This week’s T-SQL Tuesday invitation is all about puzzles. I’ve got an accidental puzzle that I’ve never quite solved, from one of my demos. I’m sure the answer will...
2019-05-14
The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.
2012-10-08
1,832 reads
The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.
2012-09-17
1,364 reads
This challenge is to generate a game scheduler based on the Teams given in a table.
2012-07-04
1,496 reads
The challenge is to find the minimal set of intervals without creating gaps.
2012-04-16
1,528 reads
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.
2012-04-02
860 reads
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other...
By Chris Yates
Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations...
Part of my job at work is to update Transact-SQL reference content. System dynamic...
Comments posted to this topic are about the item Fetch fields like email address...
Comments posted to this topic are about the item Enables Change Data Capture (CDC)...
Comments posted to this topic are about the item Free T-SQL Script: Database Schema...
I want to enable Change Tracking for a database. What is the minimum database compatibility level I need to set for the Changetable function to work correctly?
See possible answers