Connecting Tech Pros Worldwide Forums | Help | Site Map

String or binary data would be truncated.

Newbie
 
Join Date: Nov 2008
Posts: 1
#1: Nov 18 '08
what it means.can u help anyone.
this is my sql code
procedure [dbo].[Q_Update]
(@Quatationno varchar(250),
@QuatationDate datetime,
@BookNo Varchar(250),
@AutherName varchar,
@Edition int,
@price money,
@PublisherName varchar(250),
@supplierName varchar(250))
As
update Quatation set @QuatationDate=QuatationDate,@BookNo=BookNo,@Authe rName=AutherName,@Edition=Edition,@price=price,@Pu blisherName=PublisherName,@supplierName=supplierNa me where @Quatationno=Quatationno

GazMathias's Avatar
Expert
 
Join Date: Oct 2008
Location: Bristol, United Kingdom
Posts: 145
#2: Nov 18 '08

re: String or binary data would be truncated.


I most often see this when one of the fields has a ' " or , in it.

Also is:

Expand|Select|Wrap|Line Numbers
  1. @supplierName=supplierNa me
Supposed to have a space in it?

Gaz
Reply