The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--' insert into mytestvalues (:1)'--and binds the values on each iteration.

In a previous Practical .NET column I showed how to retrieve rows that hold JSON objects by querying on values in those objects’ properties. However, sometimes you’ll want to work with the complete ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.