{"id":347,"date":"2006-07-20T13:18:20","date_gmt":"2006-07-20T07:48:20","guid":{"rendered":"http:\/\/chiragmehta.info\/chirag\/2006\/07\/20\/marriage-invitationsql-server-stored-procedure-style\/"},"modified":"2006-07-20T13:18:20","modified_gmt":"2006-07-20T07:48:20","slug":"marriage-invitationsql-server-stored-procedure-style","status":"publish","type":"post","link":"https:\/\/www.chiragmehta.info\/chirag\/2006\/07\/20\/marriage-invitationsql-server-stored-procedure-style\/","title":{"rendered":"Marriage invitation……..(SQL Server Stored Procedure Style)"},"content":{"rendered":"

CREATE PROCEDURE MyMarriage<\/strong>
\n@ BrideGroom Char(NotBad),
\n@Bride Char(Good)
\nAS <\/p>\n

SELECT Bride <\/strong>FROM
\nDelhi Brides
\nWHERE
\nFatherInLaw = ‘Millionaire’<\/strong> AND
\nCarCount > 2 AND
\nHouseStatus =’TwoStoreyed’ AND
\nBrideEduStatus=’PGorAbove’
\nHavingBrothers=’NO’ AND
\nHavingSisters =’No’ AND
\nAllowRelocate =’YES’ AND <\/p>\n

SELECT Gold ,Cash,Car,BankBalance <\/strong>FROM FatherInLaw <\/strong><\/p>\n

UPDATE MyBankAccout<\/strong> SET MyBal = MyBal + FatherinLawBal <\/strong>
\nUPDATE MyLocker<\/strong> SET MyLockerContents = MyLockerContents + FatherinLawGold <\/strong><\/p>\n

INSERT INTO MyCarShed<\/strong> VALUES (‘Ford’) <\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE PROCEDURE MyMarriage @ BrideGroom Char(NotBad), @Bride Char(Good) AS SELECT Bride FROM Delhi Brides WHERE FatherInLaw = ‘Millionaire’ AND CarCount > 2 AND HouseStatus =’TwoStoreyed’ AND BrideEduStatus=’PGorAbove’ 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 + […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[166,4],"class_list":["post-347","post","type-post","status-publish","format-standard","hentry","category-forwards","tag-forwards","tag-fun","post-preview"],"_links":{"self":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/comments?post=347"}],"version-history":[{"count":0,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/347\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/media?parent=347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/categories?post=347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/tags?post=347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}