Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Date field when importing xml with SQLXML 3.0 into SQLExpress

Status
Not open for further replies.
Jimdeb03

Jimdeb03

IS-IT--Management
Dec 10, 2002
89
US
I'm importing xml files into a database using SQLXML through C# into SQLExpress

I have the data going in ok but the tables have Date fields I'd like to add with each record. This field is set to NOT NULL.

Obviously, with this field set to NOT NULL, the import process fails because there is no data in the XML.

Is it possible for SQLXML to have SQLExpress update a field with the current datetime?


 
Status
Not open for further replies.

Similar threads

smak1
  • Locked
  • Question
add structure to XML
Replies
0
Views
687
smak1
smak1
Bijan Borazjani
  • Locked
  • Question
XML to PDF
Replies
0
Views
782
Bijan Borazjani
Bijan Borazjani
cdr_greg
  • Locked
  • Question
Display XML Line Breaks in Microsoft Word Content Controls
Replies
0
Views
1K
cdr_greg
cdr_greg
198709km
  • Locked
  • Question
Grouping XML key value using XSLT
Replies
1
Views
739
atlopes
atlopes
Sunil Sharma
  • Locked
  • Question
Add Minus (-) into pattern but constrain is Munis (-) should not be first character
Replies
1
Views
711
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top