Moving information from an HTML form into a database is a two-step design ... In the first line, the SQL statement used to insert the information in the database table "table_name" is passed ...

"Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt. Having two methods gives database users flexibility ...

A common SQL habit is to use SELECT * on a query ... For instance, if you insert data into a table and then use UPDATE to change it, like I’ve just shown, that’s two separate transactions.

The basic Server Extensions that ship with UltraDev allow you to issue SQL INSERT statements, but only to one table. In many cases, you may need to insert data to multiple tables at the same time ...