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 SkipVought 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
0
0
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
145
smak1
smak1
Bijan Borazjani
  • Locked
  • Question
XML to PDF
Replies
0
Views
181
Bijan Borazjani
Bijan Borazjani
cdr_greg
  • Locked
  • Question
Display XML Line Breaks in Microsoft Word Content Controls
Replies
0
Views
171
cdr_greg
cdr_greg
198709km
  • Locked
  • Question
Grouping XML key value using XSLT
Replies
1
Views
162
atlopes
atlopes
Sunil Sharma
  • Locked
  • Question
Add Minus (-) into pattern but constrain is Munis (-) should not be first character
Replies
1
Views
157
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top