Answer - Question of the Week - 28/12/2013 - Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
605 reads
While loop in SQL server
In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....
2014-01-01
22,846 reads
Final Giveaway And Some Stats
Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012...
2014-01-01
339 reads
2013 in review
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2014-01-01
407 reads
MDX #36 – Many thanks to the reviewers
In this blog, I’d like to give special thanks to the people below who have taken time to write reviews...
2014-01-01
524 reads
2013 in review
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2013-12-31
1,194 reads
Slimming down The Voice of the DBA Podcasts
I announced in the Christmas editorial that I was discontinuing the video podcasts. Needless to say I heard a complaint...
2013-12-31
1,414 reads
Happy New Year 2014
HAPPY NEWYEAR2014
Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my...
2013-12-31
1,031 reads
Day 7 – Command ‘n Conquer
This is the seventh installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-31
27 reads
Day 7 – Command ‘n Conquer
This is the seventh installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-31
1,347 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
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