Using a rowcount in an execute SQL

Just managed to work this out by simple trial and error
I simply added this in my insert script

'#rc1# rows inserted' AS COMMENTS,

the '#rc1#' rowcount variable added the value (29) into the column plus my comments too

1 Like