Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
3,343 reads
Colleen M. Morrow
SQL Server A to Z – YEAR
SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...
2012-01-02 (first published: 2011-12-26)
2,294 reads
SQL Server A to Z – CPU-Z
How fitting that I should close out the A to Z series while I close out the year. We’ve finally...
2011-12-29
2,076 reads
A SQL Server Christmas Card
Merry Christmas everyone!
DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint
SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho
WHILE @tiers...
2011-12-22
808 reads
Pitching Pebbles – Using Certificates to Grant Privileges
If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...
2011-12-19
1,215 reads
#meme15 – Why Do You Blog?
Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15. The overall topic of #meme15 will be social networking, obviously...
2011-12-15
615 reads
SQL Server A to Z – XML
I can’t believe it’s already December. This year has just flown by. The rush of holiday events has already started,...
2011-12-08
1,746 reads
T-SQL Tuesday #025 – Tips and Tricks
This month’s T-SQL Tuesday is being hosted by Allen White (blog | @SQLRunr ). The topic: Share your T-SQL tips and tricks. ...
2011-12-06
1,252 reads
Get Involved – This Week In PASS
We’re all busy people. We have jobs, families, and responsibilities out the wazoo. Little Timmy needs to be picked up...
2011-12-05
727 reads
SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?
So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install...
2011-12-01
1,146 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers