Wedding Query..... (SQL Style) Wedding Query..... (SQL Style) CREATE PROCEDURE MyMarriage BrideGroom Male (25), Bride Female(20) AS BEGIN SELECT Bride FROM india_ Brides WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 10 AND HouseStatus = 'ThreeStoreyed' AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) 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 Bride writes the below query: DROP HUSBAND; Commit; |
All times are GMT +5. The time now is 06:37 PM. |
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.