Posts

Showing posts from April 1, 2012

The first word of Christ ...

If we accept Markan Primacy, then the first words of Christ recorded in the bible are as follows:

“The time has come,” he said. “The kingdom of God has come near. Repent and believe the good news!"

What a truly, truly wonderful thought.
I have an idea.  Let's preach this:  The time has come.  The kingdom of God has come near.  Repent, and believe the good news.  :-D


A couple things I learned about databases today

1 - In DB2, the following pseudocode doesn't work:
define cursor
open cursor
while (not end of cursor)
   make table update
   commit;
 end-while
close cursor

The reason?  The "commit;" statement closes your cursor!  you'll have to commit after exiting your loop.

2 - In SQL Server, you can end up with a database that has no owner.  (!)
To correct this, us the sp_changedbowner system stored procedure.
example: sp_changedbowner 'sa'

A more thorough treatment of this topic can be found here.

Crazy ...