请教个存储过程语法错误问题!
exec sp_executesql N'dt_DataInsert', N'@coc_LoadNo varchar(3),
@coc_Track varchar(8000),
@coc_Date datetime,
@coc_PoNumber varchar(8000),
@coc_Substance varchar(8000),
@coc_LeatherType varchar(8000),
@coc_Colour varchar(8000),
@coc_Customer varchar(8000),
@coc_WetBlueSource varchar(8000),
@coc_Elongate1 decimal(1,0),
@coc_Elongate2 decimal(1,0),
@coc_Elongate3 decimal(1,0),
@coc_LoadIntensity1 decimal(1,0),
@coc_LoadIntensity2 decimal(1,0),
@coc_LoadIntensity3 decimal(1,0),
@coc_BurstIntensity1 decimal(1,0),
@coc_BurstIntensity2 decimal(1,0),
@coc_BurstIntensity3 decimal(1,0),
@coc_Mullen1 decimal(1,0),
@coc_Mullen2 decimal(1,0),
@coc_Mullen3 decimal(1,0),
@coc_CrockWet1 decimal(1,0),
@coc_CrockWet2 decimal(1,0),
@coc_CrockDry1 decimal(1,0),
@coc_CrockDry2 decimal(1,0),
@coc_CrockFleshWet1 decimal(1,0),
@coc_CrockFleshWet2 decimal(1,0),
@coc_CrockFleshDry1 decimal(1,0),
@coc_CrockFleshDry2 decimal(1,0),
@coc_AdhesionWet1 decimal(1,0),
@coc_AdhesionWet2 decimal(1,0),
@coc_AdhesionWet3 decimal(1,0),
@coc_AdhesionWet4 decimal(1,0),
@coc_AdhesionWet5 decimal(1,0),
@coc_AdhesionWet6 decimal(1,0),
@coc_AdhesionDry1 decimal(1,0),
@coc_AdhesionDry2 decimal(1,0),
@coc_AdhesionDry3 decimal(1,0),
@coc_AdhesionDry4 decimal(1,0),
@coc_AdhesionDry5 decimal(1,0),
@coc_AdhesionDry6 decimal(1,0),
@coc_FlexWet1 int,
@coc_FlexWet2 int,
@coc_FlexDry1 int,
@coc_FlexDry2 int,
@coc_RubfastnessGrainWet1 decimal(1,0),
@coc_RubfastnessGrainWet2 decimal(1,0),
@coc_RubfastnessGrainDry1 decimal(1,0),
@coc_RubfastnessGrainDry2 decimal(1,0),
@coc_RubfastnessFleshWet1 decimal(1,0),
@coc_RubfastnessFleshWet2 decimal(1,0),
@coc_RubfastnessFleshDry1 decimal(1,0),
@coc_RubfastnessFleshDry2 decimal(1,0),
@coc_RubfastnessLeatherWet1 decimal(1,0),
@coc_RubfastnessLeatherWet2 decimal(1,0),
@coc_RubfastnessLeatherDry1 decimal(1,0),
@coc_RubfastnessLeatherDry2 decimal(1,0),
@coc_FeltPadWet1 decimal(1,0),
@coc_FeltPadWet2 decimal(1,0),
@coc_FeltPadDry1 decimal(1,0),
@coc_FeltPadDry2 decimal(1,0),
@coc_LeatherPadWet1 decimal(1,0),
@coc_LeatherPadWet2 decimal(1,0),
@coc_LeatherPadDry1 decimal(1,0),
@coc_LeatherPadDry2 decimal(1,0),
@coc_Abrasion varchar(3),
@iSuccess int', ----------------查询分析器里说这里出错。
@coc_LoadNo = '001',
@coc_Track = '',
@coc_Date = '10 28 2008 12:00AM',
@coc_PoNumber = '',
@coc_Substance = '',
@coc_LeatherType = '',
@coc_Colour = '',
@coc_Customer = '',
@coc_WetBlueSource = '',
@coc_Elongate1 = 6,
@coc_Elongate2 = 7,
@coc_Elongate3 = 8,
@coc_LoadIntensity1 = 0,
@coc_LoadIntensity2 = 0,
@coc_LoadIntensity3 = 0,
@coc_BurstIntensity1 = 0,
@coc_BurstIntensity2 = 0,
@coc_BurstIntensity3 = 0,
@coc_Mullen1 = 0,
@coc_Mullen2 = 7,
@coc_Mullen3 = 8,
@coc_CrockWet1 = 0,
@coc_CrockWet2 = 0,
@coc_CrockDry1 = 0,
@coc_CrockDry2 = 0,
@coc_CrockFleshWet1 = 0,
@coc_CrockFleshWet2 = 0,
@coc_CrockFleshDry1 = 0,
@coc_CrockFleshDry2 = 0,
@coc_AdhesionWet1 = 0,
@coc_AdhesionWet2 = 0,
@coc_AdhesionWet3 = 0,
@coc_AdhesionWet4 = 0,
@coc_AdhesionWet5 = 0,
@coc_AdhesionWet6 = 0,
@coc_AdhesionDry1 = 0,
@coc_AdhesionDry2 = 0,
@coc_AdhesionDry3 = 0,
@coc_AdhesionDry4 = 0,
@coc_AdhesionDry5 = 0,
@coc_AdhesionDry6 = 0,
@coc_FlexWet1 = 0,
@coc_FlexWet2 = 0,
@coc_FlexDry1 = 0,
@coc_FlexDry2 = 0,
@coc_RubfastnessGrainWet1 = 0,
@coc_RubfastnessGrainWet2 = 0,
@coc_RubfastnessGrainDry1 = 0,
@coc_RubfastnessGrainDry2 = 0,
@coc_RubfastnessFleshWet1 = 0,
@coc_RubfastnessFleshWet2 = 0,
@coc_RubfastnessFleshDry1 = 0,
@coc_RubfastnessFleshDry2 = 0,
@coc_RubfastnessLeatherWet1 = 0,
@coc_RubfastnessLeatherWet2 = 0,
@coc_RubfastnessLeatherDry1 = 0,
@coc_RubfastnessLeatherDry2 = 0,
@coc_FeltPadWet1 = 0,
@coc_FeltPadWet2 = 0,
@coc_FeltPadDry1 = 0,
@coc_FeltPadDry2 = 0,
@coc_LeatherPadWet1 = 1,
@coc_LeatherPadWet2 = 3,
@coc_LeatherPadDry1 = 2,
@coc_LeatherPadDry2 = 4,
@coc_Abrasion = 'aaa',
@iSuccess = 2
存储过程应该是没问题的。语法错在哪里?