Removing double spaces in a string
Removes double spaces in a string, leaving all words seperated by a single space. Run in Query Analyzer.
2004-07-21 (first published: 2004-07-05)
231 reads
Counting ocurrences in a string
Counting the number of ocurrences of characters in a string can be useful, and this script will do the job. It can easily be modified to be a function or to search for ocurrences of strings. Run it in Query Analyzer.
2004-07-20 (first published: 2004-07-05)
134 reads
Blogs
Azure Synapse Analytics new features
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing...
SQLSaturday Orlando Notes – Coffee
By Andy Warren
I like to say that the goal for any event is to meet the...
Forums
result in same line
Hello, trying to query the result by success or failure in 2 seperate...
Dropping SP's safely
Hi, Is the below script good to delete 3 sp's... Please let me know...
SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working
Hello, I have a Read-Scale AG set up. I have it failing over back...
Ask SSC