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.

How to Reindex SQL Tables. The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

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

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.

How to Check for Duplicates Before Inserting Into SQL. When you insert new records into an SQL database, you may run into issues where you accidentally overwrite records that are already present ...