【急等】 存储过程中的问题

[ahljxwy]

现有如下代码:
DECLARE @S varchar(1000)
SET @S='A,B,C,D,E'
SET @S=REPLACE(@S,',',''');'+CHAR(10)+'Insert Into 表1(value1,value2,value3) values(1,2,3,''')
PRINT 'Insert Into 表1(value1,value2,value3) values(1,2,3,'''+@S+''');'

得到如下结果:
Insert Into 表1(value1,value2,value3) values(1,2,3,'A');
Insert Into 表1(value1,value2,value3) values(1,2,3,'B');
Insert Into 表1(value1,value2,value3) values(1,2,3,'C');
Insert Into 表1(value1,value2,value3) values(1,2,3,'D');
Insert Into 表1(value1,value2,value3) values(1,2,3,'E');

现在我想要得到得下结果:
Insert Into 表1(value1,value2,value3) values(1,2,3,'A',5);
Insert Into 表1(value1,value2,value3) values(1,2,3,'B',5);
Insert Into 表1(value1,value2,value3) values(1,2,3,'C',5);
Insert Into 表1(value1,value2,value3) values(1,2,3,'D',5);
Insert Into 表1(value1,value2,value3) values(1,2,3,'E',5);

请问代码该怎么改,谢谢!

[WaterGG]

DECLARE @S varchar(1000)
SET @S='A,B,C,D,E'
SET @S=REPLACE(@S,',',''');'+CHAR(10)+'Insert Into 表1(value1,value2,value3) values(1,2,3,''')
PRINT 'Insert Into 表1(value1,value2,value3) values(1,2,3,'''+@S+''',5);'

[ahljxwy]

不对
[Quote=引用 1 楼 watergg 的回复:]
SQL code
DECLARE @S varchar(1000)
SET @S='A,B,C,D,E'
SET @S=REPLACE(@S,',',''');'+CHAR(10)+'Insert Into 表1(value1,value2,value3) values(1,2,3,''')
PRINT 'Insert Into 表1(value1,value2,value3) value……
[/Quote]

[billpu]

DECLARE @S varchar(1000)
SET @S='A,B,C,D,E'
SET @S=REPLACE(@S,',',''',5);'+CHAR(10)+'Insert Into 表1(value1,value2,value3) values(1,2,3,''')
PRINT 'Insert Into 表1(value1,value2,value3) values(1,2,3,'''+@S+''',5);'

[WaterGG]

DECLARE @S varchar(1000)
SET @S='A,B,C,D,E'
SET @S=REPLACE(@S,',',''',5);'+CHAR(10)+'Insert Into 表1(value1,value2,value3,value4,value5) values(1,2,3,''')

PRINT 'Insert Into 表1(value1,value2,value3,value4,value5) values(1,2,3,'''+@S+''',5);'

[ahljxwy]

[Quote=引用 3 楼 billpu 的回复:]
SQL code
DECLARE @S varchar(1000)
SET @S='A,B,C,D,E'
SET @S=REPLACE(@S,',',''',5);'+CHAR(10)+'Insert Into 表1(value1,value2,value3) values(1,2,3,''')
PRINT 'Insert Into 表1(value1,value2,value3) val……
[/Quote]

非常好!