TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,497 reads
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,497 reads
I talk a lot about scripting tasks on our servers to automate our regular processes, but in this case I'm...
2009-06-03
356 reads
Ran across this a while back and just getting to it, Seatguru is a site that lets you figure out...
2009-06-03
394 reads
Do you know what a Geoid is?
I’ve been working my way through Beginning Spatial with SQL Server 2008, actually “through”...
2009-06-03
660 reads
This one isn't a technical post, but it's entirely appropriate to those of us in the IT field. Today was a...
2009-06-02
798 reads
The USB not in Hyper-V thing is annoying. It actually made me stop and consider my alternatives for a desktop....
2009-06-02
777 reads
Ken Starnes from the Portland group will be having their first event on June 6th. I like the way they've...
2009-06-01
303 reads
I flew up to Birmingham Friday for SQLSaturday #7 organized by John Baldwin from Steel City SQL and a lot...
2009-06-01
716 reads
When it comes to securing a system, it's important to understand how it might be attacked. That's what surface area...
2009-06-01
1,345 reads
For those who are interested, I've got a couple of speaking engagements coming up in the next two weeks. I'll be speaking...
2009-06-01
629 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers