SQL Запрос

[Been_Lasted]

Можно использавать convert
Например так:

stmt.executeUpdate(
'insert into TmpParm (CountRecord, recid , dataareaid) ' +
'select count(*) as CountRecord, ' +
' convert(int,'+int2str(beginRecId)+') AS recid ,' +
' \''+dataareaid+'\' as DATAAREAID ' +
sqlStr +';'
);