Could you please give me an example for Inserting/updating a table from an xml, i am using SQL2000
Thanks, Abdul Rahuman [EMAIL PROTECTED] -----Original Message----- From: Askew, Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:52 AM To: '[EMAIL PROTECTED]' Subject: RE: [cf-xml] storing xml in database What I am doing is 2000 specific, I think, but I remember hearing you can add the capabilites to 7.0 somehow... a google search might turn that up. Here's some examples of what I'm going with 2000: an example table: CREATE TABLE [gen_addresses] ( [fk_person_id] [int] NOT NULL , [fk_address_type_id] [int] NOT NULL , [Phone] [varchar] (15) NULL , [Street] [varchar] (100) NOT NULL , [City] [varchar] (50) NOT NULL , [State] [varchar] (30) NULL , [ZIP] [varchar] (50) NULL , [Country] [varchar] (50) NULL , CONSTRAINT [FK_gen_addresses_gen_address_types] FOREIGN KEY ( [fk_address_type_id] ) REFERENCES [gen_address_types] ( [PK_ID] ), CONSTRAINT [FK_gen_addresses_gen_person] FOREIGN KEY ( [fk_person_id] ) REFERENCES [gen_person] ( [PK_ID] ) ) ON [PRIMARY] GO Using: select * from gen_addresses for xml auto, elements The following is returned: <gen_addresses><fk_person_id>1</fk_person_id><fk_address_type_id>1</fk_addre ss_type_id><Street>319 West CatScratch St</Street><City>Vermillion</City><State>SD</State><ZIP>57069</ZIP><Country> US</Country></gen_addresses> -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm �_________________________________________ The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading this message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. FISI*Madison L.L.C., Benefit Consultants, Inc., Long Term Preferred Care, Inc. and Cendant Strategic Marketing Group are not liable for any loss or damage arising in any way from this message or its attachments. -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm
