-
Help : Server: Msg 8152, Level 16, State 9, Line 1
When I try to update one table from another I get the following error
message, Does anyone know what may be the cause of the error :
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
Thanks
KUL
-
Help : Server: Msg 8152, Level 16, State 9, Line 1 (reply)
That error means that you are inserting data into a char/varchar column, more than what it can take.
HTH,
Vyas
Check out my page for SQL Server, ASP, VB resources,Replication FAQ and
MORE:
http://vyaskn.tripod.com/index.htm
Review of SQL Server 2000's "Federated database servers" feature:
http://vyaskn.tripod.com/federated.htm
Interesting code samples (include SQL stored procedures, VB programs):
http://vyaskn.tripod.com/code.htm
------------
KUL at 1/5/01 5:00:47 AM
When I try to update one table from another I get the following error
message, Does anyone know what may be the cause of the error :
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
Thanks
KUL
-
Help : Server: Msg 8152, Level 16, State 9, Line 1 (reply)
Thanks for your help mate I will chek these websites
Cheers
KUL
------------
Vyas at 1/5/01 5:57:53 AM
That error means that you are inserting data into a char/varchar column, more than what it can take.
HTH,
Vyas
Check out my page for SQL Server, ASP, VB resources,Replication FAQ and
MORE:
http://vyaskn.tripod.com/index.htm
Review of SQL Server 2000's "Federated database servers" feature:
http://vyaskn.tripod.com/federated.htm
Interesting code samples (include SQL stored procedures, VB programs):
http://vyaskn.tripod.com/code.htm
------------
KUL at 1/5/01 5:00:47 AM
When I try to update one table from another I get the following error
message, Does anyone know what may be the cause of the error :
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
Thanks
KUL
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|