 | |
@insertString being truncated
microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
@insertString being truncated -
07-06-2012
, 12:17 AM
#2
| |||
| |||
|
|
I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? |
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
#3
| |||
| |||
|
|
I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? Bob Sweeney |
#4
| |||
| |||
|
|
On Friday, July 6, 2012 1:17:29 AM UTC-4, Bob wrote: I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? |
Quote:
|
Bob Sweeney Erland, if you don't know the answer to my question then kindly shut the fuck up. |
I was going to post some data that might help, but considering
how you treated Erland, no. Erland might well be the most helpful
person on this newsgroup. I would not want to see him leave because
of a jerk (you).
Sincerely,
Gene Wirchenko
Sincerely,
Gene Wirchenko
#5
| |||
| |||
|
|
On Friday, July 6, 2012 1:17:29 AM UTC-4, Bob wrote: I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? Bob Sweeney Erland, if you don't know the answer to my question then kindly shut the fuck up. |
--
J.
#6
| |||
| |||
|
|
I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? Bob Sweeney |
#7
| |||
| |||
|
|
On Friday, July 6, 2012 1:17:29 AM UTC-4, Bob wrote: I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? Bob Sweeney Gene, get lost. Join erlander. |
Ah, your language is a little politer there. Keep working on it,
and you may be fit company yet.
When you finish digging that hole for yourself, what are you
going to do with it? I suggest that you might try filling it in. An
apology would be nice.
Sincerely,
Gene Wirchenko
#8
| |||
| |||
|
|
I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? Bob Sweeney |
#9
| |||
| |||
|
|
On Friday, July 6, 2012 1:17:29 AM UTC-4, Bob wrote: I am starting with a Declare @insertString varchar(8000) Then I'm creating a cursor and looping through records while setting @insertString = @insertString + 'the newest record from the cursor' This works fine but for some reason the maximum SIZE for the @insertString stops at 4000 Why is this? Again, it works fine as long as the len is 4000 or less. The table field is clearly a varchar(8000) Anybody got any ideas? Erland, if you don't know the answer to my question then kindly shut the fuck up. |
given me sufficient information, for instance the code you are having
problem, I might have been able to help.
Sure, I could produce a number of guesses, but having answered a couple
of questions on newsgroups and forums, my experience is that the root of
the problem lies in something the poster did not tell me.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.