Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

SQL Pi

A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file. Technically interesting, if less than useful. Made me curious what had been done with Pi in SQL, so went looking:

Interesting, but not incredibly useful. The problem solver portion of me can appreciate tackling something like this for the fun of it, but the more pragmatic portion of me says I should spend time on more useful things.

Which isn't to say that I've never spent time on stupid code. At various points I've had code to "net send" a sentence to another machine one word at a time (annoying to be on the other end), an exe that just emailed a mailing list to tell them that the coffee was ready, and perhaps most strange, code to convert an integer to a 12 character base 36 representation (we had an application that used them for primary keys).

Comments

Posted by Steve Jones on 11 February 2009

One of my early CS assignments in college was to perform a large calculation using LISP and manipulate the numbers as strings. I did Pi, not sure how far out but pretty far.

This was one of those short programs that I'd also stick on the demo TRS-80s and Commodores sitting in stores when I was a kid, letting them fill the screen until they crashed on the precision.

Leave a Comment

Please register or log in to leave a comment.