Friday, December 08, 2006

Fun with SQL Server ...

Read this first:

1. This has no real time usage. So try this out only when you are free :)
2. This script was just done for fun and nothing more.
3. Before executing this script change your result display mode to 'Text' (Ctrl + T)
4. There are easier way of doing the same thing. Just to make it look complex I have done this way :)

Code snippet Starts here:

Set nocount on
Declare @TblLayout table([ID] int Identity, Canvas Char(75))

Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)

--- Vz employees House ...
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x7C5F5F5F5F5F5F5F5F5F5F5F5F5F5F7C5F5F5F5F5F7C))Where ID = 5


Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x7C2020205B20205D20205B20205D207C20202020207C)) Where ID = 4

Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F5C5C5C5C5C5C)) Where ID = 3

Update @TblLayout Set Canvas = Stuff(Canvas, 43, 23 , Convert(Varchar, 0x2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F5C5C5C5C)) Where ID = 2

Update @TblLayout Set Canvas = Stuff(Canvas, 44, 21, Convert(Varchar, 0x5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F)) Where ID = 1

-- Picture of a Guy ...
Update @TblLayout Set Canvas = Stuff(Canvas, 10,10, Convert(Varchar, 0x285F5F5F5B5F5F5F29)) Where ID = 27

Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C5F5F7C5F5F7C)) Where ID = 26

Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C20207C20207C)) Where ID = 25

Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C20207C20207C)) Where ID = 24

Update @TblLayout Set Canvas = Stuff(Canvas, 10,9, Convert(Varchar, 0x5C7C5F5F5F5F2F202F)) Where ID = 23

Update @TblLayout Set Canvas = Stuff(Canvas, 9,11, Convert(Varchar, 0x5C207C20416553202F202F)) Where ID = 22

Update @TblLayout Set Canvas = Stuff(Canvas, 9,11, Convert(Varchar, 0x2F5F2F20415453205C5F5C)) Where ID = 21

Update @TblLayout Set Canvas = Stuff(Canvas, 10,9, Convert(Varchar, 0x2F202060606020205C)) Where ID = 20

Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x5F5C5F755F2F5F)) Where ID = 19

Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x5C20302030202F)) Where ID = 18

Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x2F2F2F2F2F2F2F)) Where ID = 17

--Time to travel
Update @TblLayout Set Canvas = Stuff(Canvas, 11,3, Convert(Varchar, 0x282029)) Where ID = 6

Update @TblLayout Set Canvas = Stuff(Canvas, 10,3, Convert(Varchar, 0x282029)) Where ID = 7

Update @TblLayout Set Canvas = Stuff(Canvas, 7,27, Convert(Varchar, 0x5F5F2F202F5F5F5F5F5F20202020205F5F5F5F5F5F5F5F5F)) Where ID = 8

Update @TblLayout Set Canvas = Stuff(Canvas, 5,27, Convert(Varchar, 0x287C202020202020202020207C2020207C2020202020202020207C)) Where ID = 9

Update @TblLayout Set Canvas = Stuff(Canvas, 6,26, Convert(Varchar, 0x7C205B5D205B5D205B5D207C292D287C205B5D205B5D205B5D7C)) Where ID = 10

Update @TblLayout Set Canvas = Stuff(Canvas, 6,27, Convert(Varchar,
0x7C5F5F5F5F5F5F5F5F5F5F7C2020207C5F5F5F5F5F5F5F5F5F7C)) Where ID = 11

Update @TblLayout Set Canvas = Stuff(Canvas, 7,24, Convert(Varchar, 0x303030303030303030302020202020303030303030303030)) Where ID = 12

-- Art by ....
Update @TblLayout Set Canvas = Stuff(Canvas, 54,14, Convert(Varchar, 0x417274204279205661646976656C))Where ID = 27

Update @TblLayout Set Canvas = Stuff(Canvas, 32,20, Convert(Varchar, 0x5368616D656C6573732070726F6D6F74696F6E3A))Where ID = 28

Update @TblLayout Set Canvas = Stuff(Canvas, 52,23, Convert(Varchar, 0x7661646976656C2E626C6F6773706F742E636F6D203A29))Where ID = 28

Select Canvas [ ] FROM @TblLayout


Closeing Notes: I actually got this idea after going through Roji's post here

Technorati tags: ,

3 comments:

Anonymous said...

Really Coool one.. :D

Vadivel said...

Thanks Vignesh :)

Anonymous said...

Have you seen the new India search engine www.ByIndia.com they added all the cool features of popular products like MySpace, YouTube, Ebay, Craigslist, etc. all for free to use and specifically for India. Anyone else try this yet?

ByIndia.com First to Blend Search, Social Network, Video Sharing and Auctions Into One Seamless Product for Indian Internet Users.