Using BULK INSERT to populate tables from text files. All work fine, except when inserting into tables with any columns that have a default value applied.<br><br>Take the default off, and it works fine.<br><br>Any ideas what can be done to allow the inserts with the defaults applied?
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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with BULK INSERT in SQLServer 7
- Thread starter Cartman
- Start date
A bulk insert works by pumping data straight into a table's data space. It doesn't really like default value rules as these need to evaluated on a row-by-row basis. <br><br>By the way, does it work if you inserted data into specified fields not including the ones with defaults applied? <p> <br><a href=mailto: > </a><br><a href= home</a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question