Creating a database as you've described is a lot of work, and as others have mentioned their might be better alternatives than a relational database. (or at least the typical structure for a ...

Click in the text area and type a Create Database statement using the following Transact-SQL code as a guide:CREATE DATABASE MyDatabase ON (FILENAME = 'c:\data files\my_data.mdf'), (FILENAME = ' c ...

SELECT INTO with UNION Create a new table from the results of two separate queries with the UNION keyword. Build a SELECT statement similar to the following in the Query window: ...

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 ...