Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

CREATE TABLE

The CREATE TABLE statement enables you to create a new table in the database. However, the database should already be established by the DBA. Sometimes you need to access the data in such a way that a SELECT statement would not effectively produce the desired results. An example might be that the set of data you need must be accessed and processed one row at a time through a cursor. Another example is a resultset that would require table joins so complex that the query takes a very long time to run. In such cases, it is useful to have an empty table structured the way you want the resultset structured so that you can fill in phases by using a cursor or a combination of INSERT and UPDATE statements. Table 21.9 describes the components ...