sql question

Results 1 to 2 of 2

Thread: sql question

  1. #1
    Join Date
    Dec 1969

    Default sql question

    I am running a query in query analyzer and I am getting the following error:<BR><BR>Server: Msg 8152, Level 16, State 9, Line 1<BR>String or binary data would be truncated.<BR>The statement has been terminated.<BR><BR>My query is huge, so I was wondering if there is any way to get a more specific error from query analyzer - such as the column name where the problem is occuring. Otherwise I have a long and boring task ahead!

  2. #2
    Join Date
    Dec 1969

    Default RE: sql question

    You are passing in a string into a varchar variable that is too long. For example, you might have a variable declared as varchar(50), and you are passing in a string that has more then 50 characters.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts