Madhivanan's TSQL Blog

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Blogs

Upload Image

Close it

Select File


	Like

Invite Friends

Browse by Tags · View All

sql_server	217
t-sql	211
tsql	116
sqlserver	96
BRH	78
#SQLServer	66
#TSQL	56
SQL Server	34
function	11
SSMS	9

Archive · View All

August 2007	17
August 2010	8
June 2012	7
June 2011	7
November 2007	7
August 2012	6
May 2012	6
November 2011	6
August 2011	6
October 2011	6

Home · Posts · Most Liked · Most Discussed · Ask a Question · Fans (385) · Preferences

Happy New Year from T-sql

Dec 31 2010 1:41AM by Madhivanan

In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the following code

set nocount on 

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

Tags: t-sql, sql_server, Happy-New-Year, Happy-Holidays, sqlserver, tsql, BRH,

Previous: ORDER BY ColumnName vs ORDER BY ColumnNumber
Next: Different ways to find out a Leap Year

Madhivanan

3 · 39% · 12429

Liked

Lifesaver

Refreshed

Learned

Incorrect


Like this
Post this to my facebook wall
Tweet this
This was a true life saver
Thanks, this helped me to refresh my memory
Very informative, I just learned something new
I disagree, this information is incorrect


	Submit

5 Comments

Superb, Happy new year.

commented on Dec 31 2010 5:53AM

Chintak Chhapia

40 · 5% · 1457

Please mention version of SQLServer as this will not work in SQLserver 2000

commented on Dec 31 2010 7:11AM

Hima

31 · 6% · 1776

Really wonderful! Happy New Year to you and yours!

commented on Dec 31 2010 7:40AM

Nakul Vachhrajani

4 · 33% · 10575

As Usual, Another TSQL magic from Madhivanan!

commented on Dec 31 2010 8:18AM

Jacob Sebastian

1 · 100% · 32002

For SQL Server 2000 and older try changing line 7 to:

	select top 10 id as no from sysobjects

commented on Jan 13 2011 3:12PM

Madhivanan's TSQL Blog

Happy New Year from T-sql

5 Comments

Your Comment