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
What you need to know About Azure SQL backup
Most of DBA are coming from On-premise Database Servers they know very well How...
Social: Respecting Names
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
Proud to present at this year’s VMworld 2020 conference
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Forums
SSIS DB migration from one server to other server.
Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...
Permission to view SQL jobs in SQL Server 2017
Hi, I'm using SQL Server 2017, I need to give developers only to view...
Offline Filegroups
Comments posted to this topic are about the item Offline Filegroups
Ask SSC