One of my Friend send me(in email) following stored procedure. I laughed when I read it. Please enjoy it. It is here for amusement purpose only. Never use on development or production server. This is already dangerous you have been warned. Consider it pure SQL humor.

CREATE PROCEDURE MyMarriage @ BrideGroom CHAR(NotBad), @ Bride CHAR(Good) AS BEGIN SELECT Bride FROM india_ Brides WHERE FatherInLaw = 'Millionaire' AND CarCount > 2 AND HouseStatus ='TwoStoreyed' AND BrideEduStatus='PG or Above' AND HavingBrothers='NO' AND HavingSisters ='No' AND AllowRelocate ='YES' SELECT Gold ,Cash,Car,BankBalance FROM FatherInLaw UPDATE MyBankAccout SET MyBal = MyBal + FatherinLawBal UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherinLawGold INSERT INTO MyCarShed VALUES ('BMW') END GO
When the girl comes to know about the above code she writes the below given query:
DROP HIM
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.




5 Comments. Leave new
Hilarious!
hey Pinal,
Simply superb, I found this site today and i have spent almost 4 hours to read quite few articles.
good work.
jsk,
Vipul
FANTASTIC, SUPERB
The only change in this SP is
HavingSisters =’Yes’
Otherwise
Superb
perfect, me like it so much.
cedric rwanda