tag:blogger.com,1999:blog-5888872269290260412014-10-07T04:03:30.291+01:00Bits, bobs and random thoughts...A blog on code, games, and other assorted paraphernaliaRob Ashtonhttp://www.blogger.com/profile/14918707944709568271noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-588887226929026041.post-56303669895870707072012-05-26T12:02:00.002+01:002012-05-26T12:02:53.828+01:00Entity Framework 4, Oracle and Booleans...I'd been having three days of trauma at work, but finally the sun shone through!
My team have been tasked with (re-)implementing Oracle database support in our application. We'd been working on the changes needed in the guts of the app for a few months, and had gotten to the point where all our unit tests worked fine against the code and database.
Next step was beta preparation, so we needed toRob Ashtonhttp://www.blogger.com/profile/14918707944709568271noreply@blogger.comtag:blogger.com,1999:blog-588887226929026041.post-73059277203711876662011-07-04T23:57:00.003+01:002011-07-08T23:53:30.195+01:00Project Euler, Problem 2Moving straight on to the second of the problems posed by Project Euler:
"By considering the terms in the Fibonacci sequence whose values do not exceed four million, find the sum of the even-valued terms."
Again, my mind started thinking in terms of the sets that are involved in the question:
The set of numbers that make us the Fibonacci sequence.
The set of numbers less than or equal to four Rob Ashtonhttp://www.blogger.com/profile/14918707944709568271noreply@blogger.comtag:blogger.com,1999:blog-588887226929026041.post-41466899114792509362011-07-02T00:51:00.003+01:002011-07-08T23:53:58.984+01:00Project Euler, Problem 1So kicking off with Problem 1 from Project Euler:
"Add all the natural numbers below one thousand that are multiples of 3 or 5."
It's a straight-forward question. But how best to attempt it in T-SQL?
A programming mindset oriented towards procedural languages such as C and the associated family might simply use a WHILE loop to iterate through the numbers from 1 to 999, check each one if they Rob Ashtonhttp://www.blogger.com/profile/14918707944709568271noreply@blogger.comtag:blogger.com,1999:blog-588887226929026041.post-28373446375311863992011-07-01T01:01:00.000+01:002011-07-01T01:01:01.924+01:00Toying with SQLFor some time now, I've been dabbling in Transact-SQL, Microsoft's interpretation of Structured Query Language, and SQL Server. Along the way I've learned a lot about both, for good and bad :)
I've learned a lot from reading around the subject. There are a lot of good authors out there that know a lot about SQL Server between them all, but I've always felt that I've learned best by doing, not Rob Ashtonhttp://www.blogger.com/profile/14918707944709568271noreply@blogger.com