Madhivanan's TSQL Blog

Getting Started with ASP.NET MVC - Part 6: ASP.NET MVC and Entity Framework

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


	Blogs

Upload Image

Close it

Select File


	Like

Invite Friends

Browse by Tags · View All

sql_server	217
t-sql	211
tsql	113
sqlserver	94
BRH	78
#SQLServer	65
#TSQL	55
SQL Server	32
function	11
SSMS	9

Archive · View All

August 2007	17
August 2010	8
June 2011	7
November 2007	7
November 2011	6
August 2011	6
October 2011	6
July 2011	6
September 2011	6
December 2011	6

Home · Posts · Most Liked · Most Discussed · Ask a Question · Images · Fans (212) · 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

4 · 39% · 8850

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

191 · 1% · 190

Gr8...

commented on Jan 16 2012 4:04AM .

Sandeep Prajapati

76 · 3% · 680

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

For Feb 14th.

commented on Jan 26 2012 1:47PM .

Amy

351 · 0% · 75

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