YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustome
A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.
B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.
C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.
D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.