Locate specific columns used in procs
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,057 reads
Scripts
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,134 reads
Making a table out of a list
Sometimes you are given a list of values in a stored procedure that you want to use in an "IN" clause. This is a common in Reporting Services multi value parameters.
2008-01-15 (first published: 2007-11-15)
1,026 reads
2008-01-14
1,008 reads
Generating number sequences
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
973 reads
Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,441 reads
SMS Script
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,332 reads
2008-01-04 (first published: 2007-10-27)
937 reads
Automatically generate SUID procs for any table
This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.
2008-01-02 (first published: 2007-11-08)
1,452 reads
Split by Row & Field delimitters
Like my tdard split but this will take a string and split it by 2 delimiters
2007-12-28 (first published: 2007-11-13)
1,609 reads
Blogs
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...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
Alamat BCA KCU TANGERANG CITY Telp:0817°82°5533
Telp/Wa 62817825533 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal...
Alamat BCA KCP Moch. Toha Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Moh. Toha No.A 2, RT.001/RW.001, Pabuaran Tumpeng, Kec. Karawaci, Kota Tangerang,...
Alamat BCA KCP Karawaci Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Imam Bonjol No.18, RT.001/RW.003, Karawaci, Kec. Karawaci, Kota Tangerang, Banten 15115
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers