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
Covid Thoughts, So Far
By Andy Warren
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...
How to Think Like a Certification Exam at the PASS Professional Development Virtual Group
By Will Assaf
Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...
Deploy BACPAC to Azure Managed Instance failing from SSMS?
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
Forums
Advantages and Disadvantage using Temp Table or Fisical Table
Please share your thought about advantages and disadvantages for processing using temp table or...
Do people process data from beginning of time when there is data change?
This might be a beginner developer questions but need some clarifications. What is best...
Why would I want to use Compress and Decompress functions?
in what live operational or development situation /requirement would I want to use the...
Ask SSC