Get concatenated value for a column without cursor
This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.
2010-07-06 (first published: 2010-06-14)
2,331 reads
Scripts
How to output datafiles location using sp_helpdb?
This is a quick way of outputting the location of your database files/dbsize/date created on your instance.
2010-07-02 (first published: 2010-06-06)
1,393 reads
Restore All Backups
SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED
ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'
2010-06-30 (first published: 2010-06-08)
2,855 reads
2010-06-29 (first published: 2010-06-09)
1,194 reads
Finding Ratio between two numbers
This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.
2010-06-23 (first published: 2010-06-01)
2,276 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
3,460 reads
Another way to get a table list from a string
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2010-06-15 (first published: 2010-05-13)
1,913 reads
fn_getfiledetails - a replacement for xp_getfiledetails
As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...
2010-06-14 (first published: 2010-05-07)
3,653 reads
IsNumber fails cast while IsBigInt passes cast
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
3,547 reads
A quick way to find recently entered datetime entries in tables
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-08 (first published: 2010-05-04)
1,895 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
Alamat BCA KCP Muara Karang 2 (+62 838-4945-0961)
Wa:083849450961 Jl. Pluit Karang Blok D-7-U. 211A Kav.1 & No. 211, Kav 2, RT.10/RW.3,...
Alamat Telp BCA KCP Citra 2 Ext +62 838-4945-0961
Wa:083849450961 Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02,...
Alamat BCA KCP Duta Gardenia +62 838-4945-0961
Wa:083849450961 Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda,...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers