This is a simple stored procedure, for inclusion in your script writing efforts, that strips non-numeric data from a given varchar. This is most usefull in scripts used to clean-up data such as account numbers that may include spaces, dashes and the like.
2004-09-21
250 reads
To help maintain index quality, defragging of any given index is a good thing. This will defrag ALL indecies in the current DB. NOTE: Schedule for off-hours operations. For a massive re-write of indecies, change the remarking on "--IF @indid" lines to use reindex instead of just defragging.
2004-09-21
557 reads
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
I have a lookup table that implements a system-generated Id for DRI purposes. The...
A client would like to be able to recognize similar free-texts in a text...
I want to develop my skills in database design and modeling. I found...
Ask SSC