SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power.

Example 1: Creating a Table and Inserting Data into It ... This example creates the table PROCLIB.PAYLIST and inserts data into it.

explicitly identify each table with a specific command. You can insert specific values into a table with an Identity column, but, to do so, you must first set the IDENTITY_INSERT value to ON.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form when you want to create a new table with columns ...

This way, you handle both the initial insert and the modified data in a single pass. Keep large-table queries to a minimum Queries on tables of any size aren’t free.