An open letter to the leadership of Notre Dame University

To Whom It May Concern:

Oracle-like ROWNUM in MySQL

Oracle-like ROWNUM in MySQL

It needs sometimes to exactly mimic Oracle's ROWNUM where is no possibility to initiate a counter in previous statement by

SET @rownum:=0

;.

It is still possible in a single SQL.

SELECT @rownum:=@rownum+1 rownum, t.*FROM (SELECT @rownum:=0) r, mytable t;

archived from Mark Malakanov

Dispatches from the edge

Flags of our Fathers

A book describing the lives of the 6 men pictured in the Iwo Jima flag raising picture.  The author's father was one of the 6 men.  The book describes each of them from their early days and through their training and their attack on Iwo Jima.  He also follows other members of Easy Company, the company that raised the flag.

Weight Watcher Points

So I'm starting Weight Watchers with Sharon, and had a hard time trying to figure out how many points I could eat.  Finally found this calculation at Yahoo Answers:

The Health Care Crisis

I hear a lot about the Health Care problem, but most of the solutions that I hear about are Health Insurance, not Health Care.

Nostalgia

"Nostalgia's nice enough in little bitty doses, it puts personal peach fuzz on the hard ass of history..."

— Bobby Case in Fierce Invalids Home From Hot Climates - Tom Robbins

"On the poor use of grammer"

It's a matter of usage. If a house is off-plumb and rickety and lets in the wind, you blame the mason, not the bricks. Our words are up to the job. It's our syntax that's limiting."

— Switters in Fierce Invalids Home From Hot Climates - Tom Robbins

Old Age

Old age is the one disease you don't look forward to being cured of.

— Citizen Cane

Search Triggers, Stored Procs, and Functions

Code that will search Triggers, Stored Procs, and Functions in MS SQL Server

Syndicate content