Convert int to Excel column name
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,927 reads
Peter Diplaros
Generate consecutive numbers
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,773 reads
Blogs
Using ThinOptics to Read Data
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
Set-Based vs Row-Based Database Code
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Forums
Stairway to Database DevOps Level 3: Managing Code as a Team in Git
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Creating Aggregates
Comments posted to this topic are about the item Creating Aggregates
Ask SSC