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 (389) · Preferences

Happy holidays in TSQL style

Dec 29 2011 7:24AM 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(94),no)))+ replicate(char(94),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(0x486170707920486F6C6964617973 as varchar(100))

Tags: SQL Server, #SQLServer,

Previous: Timestamp datatype - Does it store Date or Time?
Next: Just Learned posts for the month of December 2011

Madhivanan

3 · 39% · 12472

7 Readers Liked this

	antonsc229 Liked this on 1/1/2012 4:21:00 PM Profile · Facebook
	Sandeep Prajapati Liked this on 1/16/2012 4:03:00 AM Profile · Blog · Facebook · Twitter
	Suvendu Shekhar Giri Liked this on 1/4/2012 8:30:00 AM Profile · Facebook · Twitter
	Jacob Sebastian Liked this on 1/16/2012 4:10:00 AM Profile · Blog · Facebook · Twitter
	Nakul Vachhrajani Liked this on 1/16/2012 3:18:00 AM Profile · Blog · Facebook · Twitter
	Adam Tokarski Liked this on 2/27/2012 5:22:00 AM Profile
	Madhivanan Liked this on 12/29/2011 7:34:00 AM Profile · Blog · Facebook · Twitter

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

4 Comments

nice idea !!!

commented on Jan 4 2012 8:31AM

Suvendu Shekhar Giri

168 · 1% · 289

Gr8...

commented on Jan 16 2012 4:04AM

Sandeep Prajapati

60 · 3% · 926

select space(6)+cast(0x486170707920566149656E74696E6592732044617921 as varchar(100))

For Feb 14th.

commented on Jan 26 2012 1:47PM

Amy

484 · 0% · 77

what is the use for cast

cast(0x486170707920566149656E74696E6592732044617921 as varchar(100))

commented on Feb 22 2012 1:01AM

Madhivanan's TSQL Blog

Happy holidays in TSQL style

4 Comments

Your Comment