The beauty of SQL *updated with code*

[Mucman]

Have any of you written some SQL statements that were so beautiful and elegant that you wanted to print them out
on a piece of paper and hang them in your office?

I know that I got some... there's something attractive about well written and efficient T-SQL.

 

[tweakmm]

The only way you could be more of a nerd is if you printed them off and wacked to them

 

[LeeTJ]

that wouldn't make him a nerd, it would make him a perverted nerd.

 

[tweakmm]

Originally posted by: LeeTJ
that wouldn't make him a nerd, it would make him a perverted nerd.

You've obviously never gotten off to printed expressions :Q

 

[Argo]

Yes, I have.

 

[PowerMacG5]

Originally posted by: tweakmm
The only way you could be more of a nerd is if you printed them off and wacked to them

ahahahah

 

[Mucman]

I'm sure notfred's done the same with his regular expressions...

 

[Drakkon]

regular expressesions > [a-z]*
although I actually know a guy who did the SQL thing (posting them around his cubicle you sickos)...but it was with good reason to remeber how the heck to index stuff and reindex stuff

 

[Atvar]

You need to get laid soon....its....for your own good

 

[Gunslinger08]

Once you start asking your lady friends to outer left join you in bed, I will be scared.

 

[AgaBoogaBoo]

Originally posted by: tweakmm
The only way you could be more of a nerd is if you printed them off and wacked to them

So thats why you printed out 50 copies for every room and bathroom you visit in a day.... ah, I see. Very smart!

:beer::brokenheart::camera::clock::disgust::evil::frown::gift::heart::light::lips::|:moon::music:

:Q:sun::wine:

 

[Mucman]

Originally posted by: joshsquall
Once you start asking your lady friends to outer left join you in bed, I will be scared.

umm... wouldn't you want to do an INNER JOIN for that? the OUTER JOIN can result in some NULL results leaving you with you and your
manhood alone.

 

[GTaudiophile]

Wishes he knew more about SQL

 

[Martin]

example?

 

[cyclistca]

Mucman you need a woman in your life. I've written some pretty cool SQL that I can say I very proud of. However I'm not about to
start hanging it in my office.

 

[Descartes]

Show us your idea of a beautiful TSQL statement I'm certain beauty is in the eye of the beholder in this case

I'm usually prouder of my regular expressions or code than TSQL statements.

 

[Mucman]

Originally posted by: MartyTheManiak
example?

working on it... it'll be up in a few minutes.

 

[Mucman]

Here are some examples.

I'm sure it's childs play to you guys you have been doing this for a quarter of a century, but
since I just learned what SQL was a year ago, I'm happy with my progress So go easy
on me if this isn't complex enough to hang on the wall

I remember some of my first queries though... they were hurtin! Lots of needless sub-queries
and ended up doing stuff on the scripting side since I didn't know some things were possible
in SQL.

Just today I learned a handy device... I am writing an app to create playlists for my radio, and I
want to randomly fetch songs from the database.

SELECT S.songid, S.title FROM songs S ORDER BY RAND() LIMIT 50

How simple is that?

 

[Hector13]

Originally posted by: Mucman
Just today I learned a handy device... I am writing an app to create playlists for my radio, and I
want to randomly fetch songs from the database.

SELECT S.songid, S.title FROM songs S ORDER BY RAND() LIMIT 50

How simple is that?

simple, maybe, but neither RAND() or LIMIT are part of standard SQL (at least not sql 89, which is the lates widely supported version, I think)

 

[Blum81]

Originally posted by: cyclistca
Mucman you need a woman in your life. I've written some pretty cool SQL that I can say I very proud of. However I'm not about to
start hanging it in my office.

he has a poster of David Usher in his office

 

[jonmullen]

but hey if his DB supports it go for it.

 

[Mucman]

blum81, it's Pete Yorn! and before people starting thinking I'm ***, I also have a poster of the White Stripes, and The New Pornographers on there!

Hector13, Those functions were used in mysql 3.whatever. I should check if they work with firebird RDBMS because I may try migrating to that.

btw, I see someone is listening to Muc-Radio! Enjoying it?

 

[Mucman]

Man... you guys asked for code, and now everyone doesn't care anymore

 

[KeyserSoze]

That is cool. I guess all we need now is a username, passoword, and a "connect string", and we'll be on our way.






KeyserSoze

 

[Mucman]

Originally posted by: KeyserSoze
That is cool. I guess all we need now is a username, passoword, and a "connect string", and we'll be on our way.

KeyserSoze

If you had that information, whatever I posted would be irrelevent because you would simply connect to the
database and look at the schema yourself . All these scripts are internally run, so SQL Injection hacks aren't
go to happen unless you work with me

Heck, my server is public on the Internet! All you need is my root password and you can h4x0r m3! Actually, I
disable remote root logins but still...