This is from http://www.programmingsolution.net/sqlserver2005/sql-funstun/sql-funs.php
Male has the following sql procedure;
CREATE PROCEDURE MyMarriage
(
BrideGroom Male (25) ,
Bride Female(20)
)
AS
BEGIN
SELECT
Bride
FROM
[India Brides]
WHERE
FatherInLaw = 'Millionaire'
AND Count(Car) > 20
AND HouseStatus = 'ThreeStoreyed'
AND BrideEduStatus IN ('B.TECH', 'BE', 'Degree', 'MCA', 'MBA')
AND Having Brothers IS NULL
AND Sisters IS NULL
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
But the female runs the below drop command :)
DROP HUSBAND;
Commit;