populate staging table SBC_POD from Secured-Roll table 

 

 

1. RESET THE OBJECTID SEQUENCE FOR THE SBC_POD TABLE BACK TO 1

 

 

 

 

 

 

2. INSERT THE DATA FROM Secured-Roll TABLE INTO SBC_POD TABLE

error message

 

 

 

3. The error "String or binary data would be truncated" typically means that the source and target have a type mismatch. This can occur when the target's maximum length is less than the source data's actual length

The error occurs when the value persisted in a field is higher (in characters count) than the one the database column max value allows. For example if there is a simple text field which by default generates a 255 max char column in the database, the error will be thrown if entering in this field 256+ characters

 

Can not save, must drop and recreate one

 

 

 

 

4. script table drop and recreate one

 

 

 

 

 

 

5.  again,  INSERT THE DATA FROM Secured-Roll TABLE INTO SBC_POD TABLE    success

 

 

 

 

 

by

Please log in or register