Inserting XML data into SQL table using OPENXML

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rahul Chatterjee (rahul_at_benesysinc.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 17:31:42 -0500

Hello

In a scenario like below, is there any way to specify default values for the
columns without actually sending it from the DOM.

Thanks

INSERT TBLUPLOADTABLE
select * from openXML(@idoc,'CONTRACTOR/LINEITEM',1)
WITH (GROUPID int,
 CONTRNUM char(9),
 SSN char(9),
 LNAME char(30),
 FNAME char(20),
 MI char(1),
 HRSW decimal,
 HRSPD decimal,
 GROSS decimal,
 INSDATE datetime,
 PROCFLAG char(1),
 SUB bit ,
 Pension bit,
 Insurance bit,
 Vacation bit,
 Annuity bit,
 TTF bit,
 WDD bit,
 EIAP bit,
 LLMCC bit)

Relevant Pages

  • Re: Sharing a common file
    ... > Here's the scenario ... That are strange directory names - the path separator is the shash '/' ... time option. ... be to have a command line option that allows you to specify the ...
    (comp.unix.questions)
  • Re: Removing xmlns="" from XmlTextWriter output
    ... FX DOM, you have to specify the default? ... Second, in parent-child ... entity relationships, it is the normal pattern for the child to take on ...
    (microsoft.public.dotnet.xml)
  • Re: Validate, Search and Transform XML with XML Hammer 1.0 rc-2
    ... that when you select the New -> XML Parser option, ... you mean a new instance of a parser), it asks me to specify the ... a SAX or DOM Parser in the background when 'running' the 'project'. ... DTD", although it clearly did the work correctly on the file group ...
    (comp.text.xml)
  • Re: General Linking question.
    ... What is the difference between these two linking commands? ... What is the advantage and disadvantage one scenario has over the other? ... -L doesn't specify a directory. ...
    (comp.unix.aix)
  • File()
    ... It happens in VFP8 and VFP9Beta. ... returned if I specify the path I want searched. ... the file in the same scenario above. ...
    (microsoft.public.fox.vfp.forms)