Quand je fais un bcp d'une table , j'obtiens ce reultat
1000 rows successfully bulk-copied to host-file. Total
received: 1000
1000 rows successfully bulk-copied to host-file. Total
received: 2000
(...)
1000 rows successfully bulk-copied to host-file. Total
received: 14000
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
1000 rows successfully bulk-copied to host-file. Total
received: 15000
(...)
1000 rows successfully bulk-copied to host-file. Total
received: 33000
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
1000 rows successfully bulk-copied to host-file. Total
received: 34000
(...)
1000 rows successfully bulk-copied to host-file. Total
received: 4500
J'obtiens cette erreur quand je lance une simple requete
sur la table
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process.
Current transaction is canceled.
Pouvez vous m'aider ?
Comment corriger ce probleme ?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Laurent Moreau
Numeric value out of range : Tu tentes de copier une valeur numérique dans un champ trop petit.
Par exemple: Tu essayes de copier 3 000 000 000 dans un champ de type INTEGER
Integer: Nombre entier dont la valeur est comprise entre - 2^31 (- 2 147 483 648) et 2^31 - 1 (2 147 483 647).
Laurent.
"stephane" wrote in message news:098901c495ac$27587a80$
Bonjour,
Quand je fais un bcp d'une table , j'obtiens ce reultat
1000 rows successfully bulk-copied to host-file. Total received: 1000 1000 rows successfully bulk-copied to host-file. Total received: 2000 (...) 1000 rows successfully bulk-copied to host-file. Total received: 14000 SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range 1000 rows successfully bulk-copied to host-file. Total received: 15000 (...) 1000 rows successfully bulk-copied to host-file. Total received: 33000 SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range 1000 rows successfully bulk-copied to host-file. Total received: 34000 (...) 1000 rows successfully bulk-copied to host-file. Total received: 4500
J'obtiens cette erreur quand je lance une simple requete sur la table
Server: Msg 3628, Level 16, State 1, Line 1 A floating point exception occurred in the user process. Current transaction is canceled.
Pouvez vous m'aider ? Comment corriger ce probleme ?
Cordialement, Stephane
Numeric value out of range :
Tu tentes de copier une valeur numérique dans un champ trop petit.
Par exemple:
Tu essayes de copier 3 000 000 000 dans un champ de type INTEGER
Integer:
Nombre entier dont la valeur est comprise entre - 2^31 (- 2 147 483 648) et
2^31 - 1 (2 147 483 647).
Laurent.
"stephane" <stepahne.martin@trema.com> wrote in message
news:098901c495ac$27587a80$a401280a@phx.gbl...
Bonjour,
Quand je fais un bcp d'une table , j'obtiens ce reultat
1000 rows successfully bulk-copied to host-file. Total
received: 1000
1000 rows successfully bulk-copied to host-file. Total
received: 2000
(...)
1000 rows successfully bulk-copied to host-file. Total
received: 14000
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
1000 rows successfully bulk-copied to host-file. Total
received: 15000
(...)
1000 rows successfully bulk-copied to host-file. Total
received: 33000
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Numeric value
out of range
1000 rows successfully bulk-copied to host-file. Total
received: 34000
(...)
1000 rows successfully bulk-copied to host-file. Total
received: 4500
J'obtiens cette erreur quand je lance une simple requete
sur la table
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process.
Current transaction is canceled.
Pouvez vous m'aider ?
Comment corriger ce probleme ?
Numeric value out of range : Tu tentes de copier une valeur numérique dans un champ trop petit.
Par exemple: Tu essayes de copier 3 000 000 000 dans un champ de type INTEGER
Integer: Nombre entier dont la valeur est comprise entre - 2^31 (- 2 147 483 648) et 2^31 - 1 (2 147 483 647).
Laurent.
"stephane" wrote in message news:098901c495ac$27587a80$
Bonjour,
Quand je fais un bcp d'une table , j'obtiens ce reultat
1000 rows successfully bulk-copied to host-file. Total received: 1000 1000 rows successfully bulk-copied to host-file. Total received: 2000 (...) 1000 rows successfully bulk-copied to host-file. Total received: 14000 SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range 1000 rows successfully bulk-copied to host-file. Total received: 15000 (...) 1000 rows successfully bulk-copied to host-file. Total received: 33000 SQLState = 22003, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Numeric value out of range 1000 rows successfully bulk-copied to host-file. Total received: 34000 (...) 1000 rows successfully bulk-copied to host-file. Total received: 4500
J'obtiens cette erreur quand je lance une simple requete sur la table
Server: Msg 3628, Level 16, State 1, Line 1 A floating point exception occurred in the user process. Current transaction is canceled.
Pouvez vous m'aider ? Comment corriger ce probleme ?
