1
Vote

Comments In SQL

description

When having a comment in the SQL Text, for example:
 
--select top 1000 * from t1 order by c1, c2;
update t1 set c1 = c1 where c1 = '000001' and c2 = '2006-05-28 00:00:00.000'
update t1 set c1 = c1 where c1 = '000001' and c2 = '2008-01-05 00:00:00.000'
 
SQL Load Test gives me the following error:
 
c:>DbLoadTestGen.exe MyScenario trace1.xml
Processing: --select top 1000 * from t1 order by c1, c2;
update t1 set c1 = c1 where c1 = '000001' and c2 = '2006-
05-28 00:00:00.000'
update t1 set c1 = c1 where c1 = '000001' and c2 = '2008-
01-05 00:00:00.000'
 
 
Error processing the following SQL: --select top 1000 * from t1 order b
y c1, c2;
update t1 set c1 = c1 where c1 = '000001' and c2 = '2006-
05-28 00:00:00.000'
update t1 set c1 = c1 where c1 = '000001' and c2 = '2008-
01-05 00:00:00.000'
 
, the error was startIndex cannot be larger than length of string.
Parameter name: startIndex.
startIndex cannot be larger than length of string.
Parameter name: startIndex
 
C:>pause
Press any key to continue . . .
 
Dany

comments