Archive518513
-
Total Posts
:
3
- Joined: 3/12/2009
-
Status: offline
|
simple insert statement
-
Monday, April 26, 2004 5:10 AM
Guys,
Pls, Kindly try this insert statement and tell me what's the problem. Everytime I insert this data it gave me an error message Server: Msg 511, Level 16, State 1, Line 1 Cannot create a row of size 9113 which is greater than the allowable maximum of 8060.The statement has been terminated.
code:
create table tmplog
(
strlog varchar(8000)
)
;
insert into tmlog
values ('START OF CU-0 RECOVERYPRM_0 E000 0300 0000 0000 79 E8 00PRM_0 E141 DD00 5600 0BD0 79 E8 00PRM_0 E241 DD00 5600 0BD0 79 E8 00PRM_0 E341 DD00 5600 0BD0 79 E8 00PRM_0 E441 DD00 5600 0BD0 79 E8 00PRM_0 E541 DD00 5600 0BD0 79 E8 00PRM_0 E541 DD00 5600 0BD0 79 E8 00PRM_0 E641 DD00 5600 0BD0 79 E8 00PRM_0 E941 DD00 5600 0BD0 79 E8 00PRM_0 E941 DD00 5600 0BD0 79 E8 00PRM_0 E841 DD00 5600 0BD0 79 E8 00PRM_0 E941 DD00 5600 0BD0 79 E8 00PRM_0 E941 DD00 5600 0BD0 79 E8 00PRM_0 EA41 DD00 5600 0BD0 79 E8 00PRM_0 EA41 6400 0000 0000 79 E8 00PRM_0 E841 0001 1303 474C 79 E8 00PRM_0 E841 0001 2503 474C 79 E8 00PRM_0 EE41 DD00 5600 0BD0 79 E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 5400 0000 0000 79 E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 5001 6200 0000 79 E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 4000 7400 0001 79 E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 EE13 0014 0001 79 E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0420 0000 79 E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0410 0000 7A E8 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EC41 DD00 5600 0BD0 79 E8 00CU RECOVERY COMPLETEPRM_0 EB41 5000 0000 001E 7A 68 00PRM_0 EE41 6074 0430 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 E841 0001 0403 474C 79 68 00PRM_0 EE41 0600 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 02E7 401C FFFF 7A 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0410 0100 7A 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0430 0100 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0430 0200 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0211 040C FFFF 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0240 A410 0000 7A 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0460 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0240 6430 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0460 0100 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0460 0500 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0455 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0240 7440 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 07E9 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0222 64AC FFFF 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0410 0200 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0430 0300 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0215 0000 000A 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0225 0400 000A 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0410 0300 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 E841 0001 0D03 474C 79 68 00PRM_0 E841 0001 1C04 6414 79 68 00PRM_0 EE41 6074 0450 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0450 0100 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 E841 0001 2804 6414 79 68 00PRM_0 E841 0001 2D03 474C 79 68 00PRM_0 EE41 6074 0430 0400 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0217 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0227 0000 0060 7A 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0410 0400 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0430 0500 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 6074 0410 0500 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 E841 0001 1504 6414 79 68 00PRM_0 E841 0001 2703 474C 7A 68 00PRM_0 E841 0001 1803 474C 7A 68 00PRM_0 E841 0001 1003 474C 7A 68 00PRM_0 E841 0001 2804 6414 79 68 00PRM_0 EE41 0800 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0100 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 E841 0001 2F04 6414 79 68 00PRM_0 E841 0001 0703 474C 79 68 00PRM_0 E841 0001 2403 474C 79 68 00PRM_0 E841 0001 2C04 6414 79 68 00PRM_0 EE41 0700 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 C000 0000 0E42 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 E841 0001 2403 474C 79 68 00PRM_0 EE41 0100 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0100 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE41 0100 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EE00 0100 0000 0000 79 68 00 APPLICATION PRM -- CDOC PRM DESCRIPTIONPRM_0 EB00 60C6 0000 0202 79 68 00 ')
please,please,please
I word count the entire data en it only gives me 4535 characters with spaces any my variable is varchar(8000). I know I overlooked somthing but I can't find.
ASAP;
/Dabsukol
|
|
Archive518513
-
Total Posts
:
3
- Joined: 3/12/2009
-
Status: offline
|
Re: simple insert statement
-
Monday, April 26, 2004 7:02 AM
RE: please,please,please Q1 I word count the entire data en it only gives me 4535 characters with spaces any my variable is varchar(8000). I know I overlooked somthing but I can't find. ASAP; /Dabsukol A1 It seems as though it ought to work allright, perhaps you have additional columns not included... See the following which creates a similar table in tempdb: http://www.sswug.org/scriptmgr/viewscript.asp?scriptid=458 HTH
|
|
