If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...

I need for a quick one time demo to generate a bunch (500,000) clients names in a client table under SQL Server 2000.<BR><BR>Everything else in the table is loaded, the clients just don't have names.

A table does not become tables when you add rows to it, because a table already represents a collection.<BR><BR>The "plural" option should be generalized to "collection", because a collective word is ...