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)
233 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
AWS RDS SQL Server Announcements - 2020
1. Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts...
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This...
I Presented with Live Captioning and Sign Language Interpreters
I had the pleasure of presenting a full-day pre-conference session on the Friday before...
Forums
New user wants to create test DB, which menu option?
I'm new to SQL Server and using V18.4. I want to create a new...
tempdb shrinking
Hi, Need some quick help here. I am unable to shrink tempdb files. There...
Query to fetch quarter & year from date
Hi, I am having the following query to fetch day & year of a...
Ask SSC