Display All SQL DateTime Conversions
If you want a quick way to determine which format, or style, to specify when converting a datetime value in SQL to a character data type, you can use...
2014-07-18
42 reads
Display All SQL DateTime Conversions
If you want a quick way to determine which format, or style, to specify when converting a datetime value in...
2014-07-18
684 reads
SQLSaturday Orlando–A Message From Last Year Revisited
I was doing some work on the marketing for SQLSaturday Orlando and looked back at the messages we sent last...
2014-07-18
626 reads
SSC Editorial: What Is the Hardest Feature to Learn About SQL Server?
I wrote What Is the Hardest Feature to Learn About SQL Server? not really knowing what answer to expect. So...
2014-07-18
1,130 reads
Reblog: July 11 to July 17
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-07-18
428 reads
Database jokes
Sometimes when work is tough you just need to take your eyes and mind away from your working console. Jokes are...
2014-07-18
6,263 reads
Friday Followup For July 18, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-07-18
324 reads
SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I find myself fighting with SSIS because it provides less...
2014-07-17
50 reads
SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I...
2014-07-25 (first published: 2014-07-17)
32,403 reads
Quick Tips–SQL Prompt Aliases for Every Table
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-24 (first published: 2014-07-17)
9,806 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers