Another Seasonal Query, Slightly Late..

On the heels of Christmas Eve’s seasonal query from Dirk Gubbels comes this gem from Madhivanan (with a tip of the hat to Dave Edwards’ link in Log Buffer #129).

set nocount on

select space(7-len(replicate(char(42),no)))+ replicate(char(42),no*2-1) from
    select top 5 row_number() over (order by name) as no from sysobjects
) as t
union all
select space(5)+replicate(char(124),3)
union all
select cast(0x4861707079204E65772059656172 as varchar(100))

This is safe to run on any database on any SQL Server 2005 or SQL Server 2008 instance.

Nice job, Madhivanan!


Comments (4)

  1. Anonymous says:

    This post is a cousin of sorts to last December’s post regarding the OBJECT_ID function. I learned this

  2. Anonymous says:

    Here’s another seasonal query for you : select datediff ( dd , ’10/20/2008′ , ‘3/3/2009’ ) ———–

  3. Anonymous says:

    If this keeps up, I might need to define a tag for this stuff.. Our old friend Adam Machanic , perhaps

  4. Adam Machanic says:

    Can I play?




    /****/1)%2)+1,0 ,space(3+/*************************/(1%no)+ (abs/****/


    /*************/))) – ((no/***************/-1) /2)))from/*************/

    /****************/(select top 4/***/row_number()over/****************/

    /***************/(order by/*****************/name) as/***************/

    /************/no from sys/********************/.types)as t/**********/

    … I hope this renders properly!

Skip to main content