Now we’ll look at the basic types of database queries that are focused on manipulating data within a database. For our purposes, all examples are in standard SQL, and these basic functions ...

In this example, I will import data from the STEVENW/pubs database into the SQL2K/DTS database (my test environment contains a default instance of SQL 2000 called STEVENW and a named instance ...