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
272 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
560 reads
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Comments posted to this topic are about the item Connect to PostgreSQL as an...
Comments posted to this topic are about the item Growing and Keeping Up
Comments posted to this topic are about the item Third Party VDI Backup
Ask SSC