pstmt.setint(1,0);
pstmt.setNString(2,"a");
pstmt.addBatch();

pstmt.setint(1,1);
pstmt.setNString(2,"b");
pstmt.addBatch();

pstmt.setint(1,2);
pstmt.setNString(2,"cc...");
pstmt.addBatch();

pstmt.setint(1,3);
pstmt.setNString(2,"d");
pstmt.addBatch();

pstmt.setint(1,4);
pstmt.setNString(2,"e");
pstmt.addBatch();

exec sp_executesql N'insert into TEST_TABLE values (@P0,@P1)                ',N'@P0 int,@P1 nvarchar(4000)',0,N'a'

declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(4000)',N'insert into TEST_TABLE values (@P0,@P1)                ',1,N'b'
select @p1

declare @p1 int
set @p1=2
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(max)',N'insert into TEST_TABLE values (@P0,@P1)                ',2,N'cccc.....'
select @p1

--->duplicate insert happens here
declare @p1 int
set @p1=3
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(4000)',N'insert into TEST_TABLE values (@P0,@P1)                ',4,N'e'
select @p1

exec sp_executesql N'insert into TEST_TABLE values (@P0,@P1)                ',N'@P0 int,@P1 nvarchar(4000)',0,N'a'
declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(4000)',N'insert into TEST_TABLE values (@P0,@P1)                ',1,N'b'
select @p1

declare @p1 int
set @p1=2
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(max)',N'insert into TEST_TABLE values (@P0,@P1)                ',2,N'ccc...'
select @p1

declare @p1 int
set @p1=3
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(4000)',N'insert into TEST_TABLE values (@P0,@P1)                ',3,N'd'
select @p1

exec sp_execute 3,4,N'e'