Remove multiple whitespace from a string (alternat
Here's an alternate way of removing multiple white spaces by using the REPLACE command.
2005-03-08 (first published: 2005-02-22)
176 reads
Scripts
BCP all user tables of a database
This script will BCP all user tables of a database to individual files. The file names are tablenameyyyymmddhhmmss.dat To executeusp_bcp_out_alltables 'database','path','server'You will need to change your default 1) path2) server
2005-03-07 (first published: 2005-02-23)
285 reads
Table Function For Data Warehouse Time Dimension
This script creates a table based function that returns time dimension that would typically be seen in a data warehouse. The time dimension has aggregate values for week, month, quarter, half, and year.
2005-03-04 (first published: 2005-02-23)
1,254 reads
Finding Procedures with a specified text
This script will give the text of all the procedures with occurences of a specifc variable. Syscomments has a limitation of 4000 characters but this script overcomes that as it uses DMO. The output is generated in a text file. If you want the name of the procedure only. replace the line where it says […]
2005-03-03 (first published: 2005-02-25)
184 reads
Set Extended Properties for Every Table
Extended properties are a neat feature in SQL Server 2000 that let you set meta data for an individual object. This stored procedure is a baseline sproc that lets you set the properties of every object in a DB to a given value. For example, if you baseline your database at 1.5.0, you can set […]
2005-03-02 (first published: 2005-02-28)
200 reads
Load data from text file with variable columns
This script loads from a formatted text file (E.g. tab delimited) with variable number of columns using BULK INSERT. For instance, the file may have any number of columns and next load (seconds later) the same file may have a different number of columns. This script reads the first line (column names) extracting the names […]
2005-03-01 (first published: 2003-06-30)
989 reads
Script to Separate-First-Middle-Last-Name
This Script is written to Separate First , Middle & Last Name from column which is having Fullname(Fname+MiddleName+Surname)
2005-02-24 (first published: 2005-02-11)
433 reads
Correction to parsestring
The original function fails when a mistaken split char is being snet to the function.This can easly be corrected by adding an if to check the value of the @holdpos inside the loop before sending it to the substring functionif the value is 0 then break the loop
2005-02-23 (first published: 2005-02-07)
116 reads
SQL Server Database File Sizes
This script creates a SQL_Statistics table in the Mater Database and then scroll through the existing databases on the server and gathers the Servers Name, logical device name, the file name and the file size and writes it to the table alond with a date time stamp.We run it once a month to gather the […]
2005-02-22 (first published: 2005-02-01)
539 reads
Backup All or one DTs Package(s)
The script runs using vbscript code. It requires the user to enter parameters and run the script. The script uses both trusted and standard connection. The script also generate a log file each time it runs. Copy the code below and save it with .vbs extension.
2005-02-21 (first published: 2005-01-31)
297 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers