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
245 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 James-Serra
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...
Hello all, i would like to send a html Mail with sql server. But...
Hello all, I really need your help – I want to use the sample...
Hi Forum, I have a table that uses the script below to create fields...
Ask SSC