Friday, June 6, 2008

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

Wedding Query........ (SQL Server Stored Procedure Style)
CREATE PROCEDURE MyMarriage@ BrideGroom Char(NotBad), @ Bride Char(Good)
ASBEGIN
SELECT Bride FROM Bahrath Matrimony Brides WHERE FatherInLaw = 'Millionaire' ANDCarCount > 2 AND HouseStatus ='TwoStoreyed' AND BrideEduStatus='PG orAbove'HavingBrothers='NO' AND HavingSisters ='No' AND AllowRelocate ='YES' AND 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
.. (Scroll down)
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Then the wife writes the below query:
FORMAT HUSBAND

No comments:

How to Get files from the directory - One more method

 import os import openpyxl # Specify the target folder folder_path = "C:/Your/Target/Folder"  # Replace with the actual path # Cre...