Fwd: Award Winning SQL Query !!!!!

3 views
Skip to first unread message

Vairamuthu Rajalingam

unread,
Oct 19, 2013, 12:24:30 AM10/19/13
to ccet group, chinna...@gmail.com, chandru g, nari, Manickam Kandasamy, Hemalatha Velusamy, Hema Raji, hema...@rediffmail.com, Keerthikha Subramaniyan, Janani .B, jaga deesan, jai Nagarajan, Jai Vadivel, Akila Balasubramaniyan, balraj, Vincent David Raj, Deepthi S, D'Souza, Sharal Sandhya, bree...@gmail.com, Gowrisankar Shanmugam, suresh george, govindaraj...@csscorp.com, kannan, Lakshmi Priya, Muthiah Venkatesan, nagasrasa, Pandy Thanaraj, Thangaraj V, thirumaniraja s



Wedding Query........ (SQL Style)

HUSBANDS QUERY

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= Null

AND Sisters =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


Then the wife writes the below query:


DROP
HUSBAND;
Commit;

 





--

WITH REGARDS...,


Er.K R VAIRAMUTHU
BE ,cse

Official Mail : vaira...@vamsoft.in
mobile no:+91 9003796999
Reply all
Reply to author
Forward
0 new messages