Skip to main content

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: ,

Comments

Anonymous said…
Really Coool one.. :D
Vadivel said…
Thanks Vignesh :)