TSQL Challenge 58 - Playing Chess in TSQL – Part 1
Your job is to read the input string and generate a result set that represents the position of pieces in a chess board.
2011-06-13
1,742 reads
Your job is to read the input string and generate a result set that represents the position of pieces in a chess board.
2011-06-13
1,742 reads
Your job is to scan the trades data and identify combination of trades that match a given rollup data.
2011-05-30
884 reads
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,500 reads
This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits
2011-05-02
1,291 reads
Your job is to write a query that identifies the longest matching country/area code from each phone number based on the information stored in an area-code reference table.
2011-04-18
1,185 reads
A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.
2011-04-04
1,519 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,616 reads
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,696 reads
The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.
2011-02-21
1,701 reads
Several technicians are sent to a customer premises to do a certain maintenance work. Your task is to process the activity log entered by each technician and identify overlaps.
2011-02-07
1,393 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers