Using a function to parse/return the Nth field of a delimited column
A useful SQL function to parse a single string with delimited values for the "N"th occurrence
2009-11-06 (first published: 2009-10-15)
1,439 reads
Scripts
Custom cleanup procedure for backup files
There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.
2009-11-05 (first published: 2009-10-09)
1,544 reads
Retrieve consecutive records from the table based the value difference
Retrieve consecutive records from the table based the value difference
2009-11-04 (first published: 2009-10-06)
949 reads
2009-11-03 (first published: 2009-10-06)
1,946 reads
Generating Rollback Proc with CDC
This will generate a rollback procedure for any table with CDC enabled for all columns
2009-11-02 (first published: 2009-10-08)
1,044 reads
Ultimate Alter Script generator
In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.
2009-10-30 (first published: 2009-10-01)
1,349 reads
Script SQL Table Schema as XML-XSD
When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.
2009-10-28 (first published: 2009-10-06)
1,514 reads
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
2009-10-26 (first published: 2008-09-18)
6,036 reads
2009-10-21 (first published: 2009-10-01)
2,303 reads
The Ultimate Table Searcher Mk2
Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.
2009-10-20 (first published: 2008-11-04)
897 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Forums
BCA KCU TEGAL | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa Tengah...
BCA KCP Dakota | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Dakota No.Raya 42, H dan 46, Sukaraja, Kec. Cicendo, Kota Bandung, Jawa...
BCA KCP Mohamad Toha | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253 @BCA...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers