Hi guys What about a function that converts a number figure into words.This sample script is to demonstrate the procedural capabilities of SQL Server . Samples select fig2words(10) will give --Ten-- ,select fig2words(103) will give --one hundred and three -- The author uses much under utilized capability of SQL Server the recursive function calls to […]
2003-11-11
573 reads
This is a bummed version of many of the "csv creating" scripts I've seen. No need to use a temp table or loop; the string can be built with one select statement (Select @String = isnull(@String + ',','') + Column From Table)
2003-11-10
390 reads
Use SQL-DMO to find database size used for more than one sql server in your enviroment.
2003-11-10
192 reads
Sometimes it's necessary to strip non-numeric characters from the string, so you can convert to integer without error. Often it happens when you want to use stored procedure, especially system procedures. The output there can be already with some characters (MB, KB and such), but you want this result to be used for your own […]
2003-11-10
1,336 reads
This will make a comma seperated list from a column using 2 select statements.
2003-11-07
214 reads
This stored proc notify the user(s) if the data/log file grew. When you execute it for the first time it will get the data/log files sizes and inserts in a table. Next time when you run the script if will compare the current size with the previous files size. This script must need sqlmail configured […]
2003-11-07
1,520 reads
We can use this sp to clear data in tables. I mainly created this sp for two reason. 1.This is useful to commence the testing from scratch. 2.Whenever we ask the database backup from our customer. They hesitant to give the production database because of confidential. I have used Delete and Truncate statement to clear […]
2003-11-06
189 reads
sp_ExecVBScript allows you to execute either a .vbs file or an ad-hoc VBScript command within a T-SQL batch. Note that the command (whether it be ad-hoc or contained in the .vbs file) cannot have any code that requires user input (such as Input Boxes or Message Boxes).
2003-11-05
7,714 reads
Not my script but a guy a work with (Bruce Canaday). This will restore all databases in a given directory. It will also create the data and log directories if they don't exist. A DR Drill dream :).
2003-11-05
3,038 reads
I modified mbenothmane's script..plz refer to "Paged data without temp table and without cursor(http://www.sqlservercentral.com/scripts/contributions/947.asp)"
2003-11-03
137 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers