My life has seen two milestones last week: my sister turned 21, and my best friend has left (again) to study medicine in a foreign country. So, naturally, each deserved to be celebrated in its own proper way, by going to Las Vegas and Disneyland, respectively.
I found a link today describing “Things that every man should do before he dies.”
Needless to say, I was very disappointed because the list seems to have been written by editors of Stuff or Maxim, and let’s face it, every one of us has done at least 4 or 5 things on this list multiple times.
To this, I answer with my own list of Things Every REAL Man Should Do Before He Dies
It’s been probably more than five years since I’ve been addicted to a TV show (no, the NBA and WC2006 does not count). I’ve been able to take great pride in the fact that I seldom watch TV. I basked in my snobbishness. Until now.
Scrubs is one refreshingly funny TV sitcom. What it lacks in canned laughter, it more than makes up for in its weird sense of humor, oddball characters, and relatively realistic plot lines. It also helps that one of the main doctors played the character of Bob Slydell from Office Space (you know, the Michael Bolton fan who admires Bolton’s version of When a Man Loves a Woman) portraying a world-class jerk with a soft heart.
This show is a funny take on the entire field of medicine, but not as dark as House — another one of my favorites. Since I got the DVR, it has been an endless barrage of Scrubs. O, waiting-for-a-show-feeling, how have I missed you!
The following in MySQL:
describe <table_name>;
is the same as MSSQL’s:
select * from information_schema.columns where table_name='<table_name>';
How do you drop an unnamed constraint (in this case a primary key) from a table in MS SQL? After two hours of searching? The answer:
First, find the constraint name using
select * from information_schema.CONSTRAINT_COLUMN_USAGE;
Then, simply:
alter table table_name drop constraint constraint_name;
THEN, to add a new primary key
alter table table_name add new_column int identity(1,1) primary key not null;