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
233 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
556 reads
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Comments posted to this topic are about the item Numeric and Decimal, which is...
I have zero front end coding skills; last time I worked with any code...
Hello, i have a table called Codes and having below columns Declare table Codes(IdCode...
Ask SSC