Thread: Wedding In SQL
View Single Post
sunils
Account Manager

sunils's Avatar

Join Date: Jan 2008
Posts: 2,145
Credits: 31,316
sunils has a reputation beyond repute
Location: Chennai ,India

Send a message via AIM to sunils Send a message via Yahoo to sunils
Quote  
09-24-2008, 05:48 AM
Wedding In SQL

Wedding Query........ (SQL Server Stored Procedure Style)

CREATE PROCEDURE
YourMarriage
@
BrideGroom
Char(NotBad) ,
@
BrideChar(Good)

AS
BEGIN

SELECT Bride FROMindia_Brides

WHERE

FatherInLaw = 'Millionaire'
AND

CarCount > 2
AND

HouseStatus ='TwoStoreyed'
AND
BrideEduStatus='PG
orAbove' AND
HavingBrothers='NO'
AND
HavingSisters ='No'
AND
AllowRelocate ='YES'


SELECT Gold ,Cash,Car,BankBalan ce 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;


__________________
Sunil Sankar
-------------------------------------------------------------------------
Account Manager



Reply With Quote
sunils is offlineReport Post