This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names of the columns, the names with their datatypes, the list of columns with each one set to an identically-named variable, and a list of variables with the same names as the […]
2003-08-12
210 reads
Takes a simple string of delimited values, and returns a table type of the values stripped out. This can be easily incorporated in existing SQL statements utilising standard joins. Classic example of a UDF returning the TABLE data type.
2003-08-10
429 reads
The server goes down and you are scrambling to remember settings, file names, locations, etc. about your databases on that server. This script captures that useful information before a serious problem occurs. I run it as an OSQL (ISQL) job and send the output file to my backup folder so the infomation goes to tape […]
2003-08-07
675 reads
It is sometimes necessary to have information regarding the database objects like stored procedures and triggers for e.g. we need to get information about a stored procedure like what paramters it has and so on.The sp_help system stored procedure comes in handy.What this store procedure does is that it returns result set. The result will […]
2003-08-07
191 reads
Purpose: To create a User Defined SQL Function that can convert a string into a Proper Case string.Installation: Run the Create Function First then run the Alter Function Statement directly after.
2003-08-07
201 reads
This script will output an estimate for the space required for a given number of rows for a specified table; the estimated size is based on the data produced by the "sp_spaceused" stored procedure.The script is written as stand alone, though it also lends itself to creation as a stored procedure, and can be run […]
2003-08-07
4,770 reads
UDF Random Password GeneratorYou can not use the RAND function directly from a User Defined Function. So the UDF I wrote "fn_RandomPassword" uses the view "view_RandomPassword8" to get the random charaters.Having the random password generator is useful if you need to insert a large number of users into a table with random passwords assigned.For example […]
2003-08-07
383 reads
This VBS function will convert a string into Proper Case (i.e. This Is Proper Case) during the execution of the DTS package. Wrap the DTSSource function with the PropCase function and the result is a Proper Case transformationexampleFunction Main() DTSDestination("Field1") = PropCase(DTSSource("Col019")) Main = DTSTransformStat_OKEnd Function
2003-08-05
215 reads
This script will find all foreign key contraints in the database it is run on. Includes.Name of Foreign KeyName of table FK is onName of column FK is onName of table FK referencesName of column FK references
2003-08-01
143 reads
Purpose : This routine will dump the transaction logs based on the percentage on how full the transaction logs are based on parmeter from the logthres table […]
2003-08-01
258 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers