Hello all,
Are there any issues with CFqueryparam using insert statements that I should
know about?
# MyTable has about 4.5 million rows
# MyTable.MyField is an nvarchar(900)
Inserting into MyTable with a cfqueryparam takes around 6000ms (extremely
slow), while inserting without a cfqueryparam
Books online says it better, but in short:
Say your table has a trigger on it, and that trigger inserts something into a
different table, @@identity returns the ID from the insert caused by the
trigger, rather than the ID you actually want.
scope_identity() knows what 'scope' you are working